MySQL Forums
Forum List  »  Replication

MySQL 5.7.17 GTID Replication always breaking
Posted by: Christian Huck
Date: February 24, 2017 03:05AM


as mentioned in the topic we have the following issue:

In short:

After transfering the Dump Export from the Master to the Slave, importing it and renabling the replication we get PK Errors after some time.

In long:
We are using MySQL 5.1.17 with GTID enabled.

We have a Master-Master scenario; but we make sure that all the traffic goes only to the first node.

What we do on both nodes:
stop slave;
reset slave;
reset master;

Then We do a full export on node A transfering the data directy to node B like this:
mysqldump --defaults-extra-file=/etc/ --user="root" --all-databases --single-transaction --add-drop-database --triggers --routines --events | mysql --host=nodeB --port=3305 --user=root

This takes a while(~1 hour). All db's sum up to about 25GB.

After completing the import we start the slave on node B.

It starts appy all changes on but after some time (seconds) the replication stops with this kind of errors:

Last_SQL_Error: Error 'Duplicate entry '4' for key 'PRIMARY'' on query. Default database: 'survey'. Query: 'INSERT INTO `survey_survey_49945`
(`49945XF836X27154`, `49943X8C36X27157`,`lastpage`,`startlanguage`) VALUES ('1', '',2, 'de-informal')'

Game Over.

We've tried this procedure many time with differnt settings but always end up with the same issue.

Help is very much appreciated !

Options: ReplyQuote

Written By
MySQL 5.7.17 GTID Replication always breaking
February 24, 2017 03:05AM

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.