Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
# Percona Toolkit: check consistency pt-table-checksum --databases mydb h=primary,u=root,p=pass # Output shows chunks that differ between primary and replica # Fix inconsistencies pt-table-sync --execute --replicate=percona.checksums h=primary # Check for writes on replica (should be zero) SHOW STATUS LIKE "Com_insert"; SHOW STATUS LIKE "Com_update"; SHOW STATUS LIKE "Com_delete";
Result
Open