We are very happy to introduce an new MySQL utility called
'mysqlrplsync' that can check the data consistency of an active
replication system. This utility is one of the new utilities
included in MySQL Utilities release-1.4.2 RC. The other utility
is the multi-source replication utility, mysqlrplms.
In a nutshell, the mysqlrplsync utility allows you to check the data consistency between servers in an active replication system. The utility reports missing databases and tables as well as data differences (per table) between the servers. A sophisticated synchronization algorithm that utilizes a table checksum is applied on the active replication …