We recently introduced 'mysqlrplsync' in MySQL Utilities
release-1.4.2 RC. This new utility allows users to check the data
consistency of an active replication system. In this blog we
provide more details about how 'mysqlrplsync' works.
In an active replication topology, slaves may be slightly behind the master in processing events. Depending on the workload and capabilities of each slave, transactions may be applied at different times. Should this occur and something untoward happen to one of the slaves (such as a user making a manual change directly on the slave), a synchronization process may be required to ensure that the slaves …