Data Consistency Verification and Repair Between MySQL Primary and Replica Using Percona Toolkit
pt-table-checksum
Prerequisites (Must Verify Before Running Checks)
Only a single host can be specified, and it must be the IP address of the primary database.
The tool adds S (shared) locks on tables during the check.
If the binary log format on the primary or replica is not STATEMENT, you must use the --no-check-binlog-format option.
Before ...
Posted on Thu, 28 May 2026 19:46:17 +0000 by jack bro