Re: MySQL Replication Missing Random Records

[Peter Brawley]

You have two problems ... (i) missing rows and/or updates on the replica, (ii) causes of those errors.

The only failsafe method I know to re-sync is to reset the replica/slave, see that topic at https://www.artfulsoftware.com/infotree/mysqltips.php.

For finding the cause(s) of those errors, I think you'll need to canvas all the possibilities listed at https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html#:~:text=The%20%E2%80%9Csafeness%E2%80%9D%20of%20a%20statement,refer%20to%20it%20as%20unsafe.