… (especially if replicating over unreliable long distance networks), MySQL bugs on master or slave, hardware problems and few others. In any case… described and when use Maatkit mk-table-checksum to check what tables are out of sync and when use mk-table-sync to resync them. Last method works in particularly well in case you can afford to run for a while with slaves…