0

Currently, we have MySQL master-slave replication. Both master and slave servers have Mysql 5.5 Currently I need to add one more Master server having version 5.7.

Is it possible to add Multiple masters to a single slave server?

One master and slave is having Mysql 5.5 and new Mysql server is 5.7

Is it possible to configure Master-slave replication with different MySQL version?

1 Answer 1

0

When replicating, the master version must be the same or less than the version on the slave. If this isn't the case, the master may inject binary log messages the slave doesn't understand.

The master version / slave version should stay between on major version. So a 5.6 master is ok to a 5.5 slave but a 5.7 slave is too much, there may be deprecated messages in 5.6 that a 5.7 slave will not understand.

Multiple masters are possible with 5.7 multi source replication..

2
  • My situation is currently the master version and slave version is same (5.5). Planning to add one more master with version 5.7 for the same slave. How to do this? multi-master is possible in 5.5 version (slave server is 5.5)
    – adminz
    Commented Nov 5, 2018 at 23:11
  • Sorry, you can't get new features on old versions. The slave version has to be 5.7 to have multi master capabilities. You'll need to update versions, one major version at a time, slave before master, until 5.7 to get the new features you want.
    – danblack
    Commented Nov 5, 2018 at 23:36

Your Answer

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

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