Single slave – multiple master MySQL replication

Best way to achieve that would be a real backup solution… but when you do it the way you describe define one slave instance per master – this way you stay flexible, for example if any change is needed you could even move one or more of the slave instances to another machine without any influence on the other slaves/masters…

EDIT – as per comments:

For a description on how to setup multiple instances of MySQL on the same machine see for example

http://dev.mysql.com/doc/refman/5.1/en/multiple-servers.html
http://www.ducea.com/2009/01/19/running-multiple-instances-of-mysql-on-the-same-machine/
Multiple MySQL instances on a single machine
This keeps you even flexible enough to have different MySQL versions in parallel (identical per slave/master combination)…

发表评论

电子邮件地址不会被公开。 必填项已用*标注