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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Your replication configuration
In fact, MySQL replication is supported across major releases as long as the two releases are consecutive, so
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).
If you are copying the files from another machine of a different version, don't forget to run
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.