Not the answer you need?
Register and ask your own question!

about mk-table-sync safety consultation

linwaterbinlinwaterbin EntrantInactive User Role Beginner

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    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
  • linwaterbinlinwaterbin Entrant Inactive User Role Beginner
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.