Sample Header Ad - 728x90

how to make sure pt-sync-table data is the latest?

0 votes
2 answers
1127 views
the first step is to checksum difference and record into percona.checksum table pt-table-checksum h=xx,P=xx,u=xx,p=xx method=dsn=h=xx,D=xx,t=xx --databases=kobe the second step is to print the repair SQL into a file pt-table-sync --print --sync-to-master h=xx,P=xx,u=xx,p=xx >repair.sql and I need to take this repairsql file to developers,show them how many records are difference, difference detail, and let them make sure。Ater that I execute the repair sql so my question is what I execute this old repair SQL, the new data is inserting ,and the new difference is creating, maybe this old repair SQL will cover the latest data ! can anybody help me ? thank you !
Asked by LawrenceLi (321 rep)
Oct 18, 2016, 02:26 AM
Last activity: Aug 8, 2025, 04:03 PM