Contents
Can a MySQL slave connect to a different master?
Each mysql slave instance will connect to a different master. The datadir for each slave instance will also be separate. Assuming you are using some flavour of unix OS, you could set up a cron job to stop and start each instance to keep the load average to a minimum.
What’s the best way to setup multiple masters in MySQL?
Using MySQL 5.5’s Semisynchronous Replication can allow you to tune the MySQL Heartbeat characteristics so as to minimize replication losing its place due to any significant network latency. If you have multiple masters, circular replication is a must.
Do you have to have multiple instances of MySQL?
You will have to use multiple instances of mysql. If you are having 6 masters and you are trying to put all the slaves on one physical machine, you will need 6 instances, Each mysql slave instance will connect to a different master. Each slave instance will be on a different port.
How does a super master work in MySQL?
These all stay in sync via one server (supermaster) that all can communicate with. All the servers only communicates with supermaster, they are not aware of any other server. The super master it self is a mirror of the other servers, just with the added service of syncing them all.
Can a slave be a slave to more than one master?
If each Master have a distinct Database that is mutually exclusive from other Master, you could have a Slave be a Slave to just one Master. Then, when all changes are posted, you would stop replication, run CHANGE MASTER TO command to point the Slave at a different Master.
Is there a native solution to support multiple masters?
There is not a native solution in MySQL to support multiple masters, but there are some theoretical alternatives: Option 1. MariaDB 10, which has everything in MySQL 5.5, some things from MySQL 5.6, and some new things.