MySQL Forums
Forum List  »  Replication

Mysql 8.0: server restart breaks replication
Posted by: Eugene Zheganin
Date: October 18, 2018 07:57AM

Hello,

at least for me after migration new installations on 8.0 it really seems like server or mysql instance restart breaks the replication: after each restart I got duplicates on the primary keys, and looking at it's content I can see that it really looks like the slave SQl thread has inserted some of the binlog data but hasn't update the pointer to it, because these duplicates are exactly the same as they should be.

This behaviour is new in 8.0, as I run several 5.6/5.7 replication setups.
How can I get rid of these ? Right now I simply delete the duplicate data and start the slave threads all over.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql 8.0: server restart breaks replication
861
October 18, 2018 07:57AM


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.