MySQL Forums
Forum List  »  Replication

Re: MySQL Replication Missing Random Records
Posted by: Peter Brawley
Date: June 14, 2022 04:49PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Replication Missing Random Records
400
June 14, 2022 04:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.