about mk-table-sync safety consultation

[scott.nemes]

Hi linwaterbin;

The tool wants to make the changes on the master so that the slave does not fall further out of sync.

If you just want to check if your slaves match, you could instead use pt-table-checksum on a regular basis, and then use pt-table-sync once you find a difference and actually need to fix it by making the changes on the master to replicate to the slaves.

-Scott

[linwaterbin]

@scott.nemes;26706

Hi linwaterbin;

The tool wants to make the changes on the master so that the slave does not fall further out of sync.

If you just want to check if your slaves match, you could instead use pt-table-checksum on a regular basis, and then use pt-table-sync once you find a difference and actually need to fix it by making the changes on the master to replicate to the slaves.

-Scott

thx scott，we have mk-table-checksum run all of our 30000+ mysql instances on a regular basis，but when finding data inconsistent，the cost is expensive for redo slave，so we want to pt-table-checksum automatic repair data inconsistent