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

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

JDBJDB EntrantCurrent User Role Beginner
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!
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.