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
68
June 14, 2022 04:49PM


Sorry, only registered users may post in this forum.

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.