MySQL Forums
Forum List  »  Replication

Re: Structure changes breaking replication on slave
Posted by: Rick James
Date: March 22, 2014 08:08AM

I don't know what will prompt that particular error, but you have two things that need fixing -- CHARACTER SET and (200). The former could lead to inconsistencies due to inability to convert characters; the latter could lead to inconsistencies due to truncation.

If the VARIABLE binlog_format is set to MIXED or ROW, that may further lead to the error message -- RBR needs more precision in what is replicated.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Structure changes breaking replication on slave
819
March 22, 2014 08:08AM


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.