pt-table-sync tool not working

06-19-2014, 02:48 AM

Hi Team,

I have setup pt-table-checksum and pt-table-sync for fixing the data issues between master and slaves.
when i ran pt-table-checksum i found few tables were not sink with the master tables,then i fired pt-table-sync it's applied some inserts into that particular table.

Then in the next pt-table-checksum run i'm able to see the old table which had updated by the pt-table-sync(this shouldn't come right ?). what is reason of this ?

would make changes directly on specified. If you have other slaves, they would not be touched and if they are out-of-sync with the master, then when you run pt-table-checksum again, the diff would remain.

The recommended way to sync master and all slaves is to use --replicate, e.g.