Buy Percona ServicesBuy Now!

pt-table-checksum then sync on live DB/Tables being written to

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-checksum then sync on live DB/Tables being written to

    Hi.

    So I want to implement a checksum and sync on a Master + 8*Slaves topology. The Master is always being written to and I'm presuming that if I checksum then sync it's not going to work as changes will have happened in between creating master and slave checksums, and then between running checksum and sync tools?

    Is my only option to pause writes to the Master for the pt-table-* tools to do their thing?

    Thanks!
Working...
X