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
Last activity: Aug 8, 2025, 04:03 PM