Most of us used to get errors like (Row not found, Duplicate row
etc) on slave in Master slave replication and sometimes it is
very difficult to find unsynced data and fix it while we know
table name(s).
There are few recommended tools from percona to check replication
integrity and fixed unsync data:
1. pt-table-checksum: performs an online replication
consistency check by executing checksum queries on the master,
which produces different results on replicas that are
inconsistent with the master.
2. pt-table-sync: synchronizes data efficiently …
Community journal
Follow the feed
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Showing entries 1 to 1 of 1
« Previous |
Next »
