MySQL Forums
Forum List  »  Replication

Re: Table definition on master and slave does not match,
Posted by: Peter Brawley
Date: April 07, 2017 02:56PM

Well, replication experience tells me keeping master-slave diffs minimal minimises replication errors, but with engines I may be mistaken, certainly https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-diffengines.html says so.

So, why do you need Mixed format, what is column 23 of that table, and what MySQL version, have you tried setting up a test replication instance with just these two tables in first Statement then Mixed formats?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Table definition on master and slave does not match,
616
April 07, 2017 02:56PM


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.