MySQL Forums
Forum List  »  Replication

Re: MySQL master-slave migration
Posted by: Peter Brawley
Date: April 10, 2016 02:50PM

Quote

One master A running 5.1 with one slave B running 5.5. Master B has 7 slaves with one 5.1, one 5.5 and five 5.6. It has been running fine with no issues for years.

Maybe best described as excellent luck:

"MySQL supports replication from one release series to the next higher release series ... However, you may encounter difficulties when replicating from an older master to a newer slave if the master uses statements or relies on behavior no longer supported in the version of MySQL used on the slave."

-- https://dev.mysql.com/doc/refman/5.7/en/replication-compatibility.html

> Is it because of the compatibility issue when we copy old version of mysql tables from 5.1 to 5.7?

Many incompatibilities from 5.1 to 5.7 (eg see http://www.artfulsoftware.com/infotree/mysql_incompat.html)

Seems you'll have to get master & slave versions within MySQL's replication specs, fixing data as you go.

And, do you have to stay with MyISAM?

Options: ReplyQuote


Subject
Views
Written By
Posted
2592
April 10, 2016 12:50PM
Re: MySQL master-slave migration
970
April 10, 2016 02:50PM
761
April 10, 2016 05:37PM
799
April 10, 2016 10:48PM


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.