2

I have a master database running mysql 5.5.11, and I am planning to setup a new slave. I am planning to use the 5.5.30 as it is the latest version. For setting up new slave, I am copying files from master 5.5.11 version. Will there be any compatibility issues?

2 Answers 2

2

Your replication configuration 5.5.11 -> 5.5.30 is a supported configuration and there is no real justification for deploying a new slave using old software.

In fact, MySQL replication is supported across major releases as long as the two releases are consecutive, so 5.1.x -> 5.5.x is supported and 5.5.x -> 5.6.x is supported.

The only caveats are that the slave should be the same version as -- or newer than -- the master, and if you're doing circular replication, you should not have more than two versions of MySQL in the chain (and best practice suggests that they be identical in this case).

http://dev.mysql.com/doc/refman/5.5/en/replication-compatibility.html

If you are copying the files from another machine of a different version, don't forget to run mysql_upgrade on the new slave.

1
0

I guess it's good to have the same version at both ends. By good, I mean that 5.5.11 might have bugs that have been fixed in 5.5.30 with respect to replication, so I guess it's safer to use the same versions.

Of course, you can always try and test with your data. But test well. You can run this scenario for a few days to see if something comes up.

2
  • I am worried now. I will go back to 5.5.11.
    – Boolean
    Feb 22, 2013 at 20:04
  • You shouldn't worry much. As I said, test before using 5.5.30. If you can run this setup for some time, you will have more confidence that the different versions solution works fine (for your setup always). I guess you cannot upgrade the master to 5.5.30, this would be the best option. Feb 22, 2013 at 20:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.