This looks like statement based replication, which can come out of sync if you're not careful to make your statements deterministic. Any use of random(), as a

This looks like statement based replication, which can come out of sync if you're not careful to make your statements deterministic. Any use of random(), as a trivial example.