Re: Multiple masters to single slave
Posted by:
Rick James
Date: December 19, 2008 12:30AM
A slave can have only one master.
You can have multiple slaves on one box -- but you need to keep the data and my.cnf (my.ini) and port different. This won't solve the problem because you still cannot have a single mysql instance reading from all the tables in the various "slaves" on the box.
If your replication traffic is low, you could programatically SLAVE STOP; CHANGE MASTER ...; wait awhile, then move on to another master. There is no problem with the slave "picking up where it left off". But you had better have different databases and/or tables on the masters; else the slave would be quite confused.
Subject
Views
Written By
Posted
8457
December 12, 2008 09:37AM
Re: Multiple masters to single slave
4238
December 19, 2008 12:30AM
3809
March 02, 2009 05:57PM
3436
April 07, 2009 01:03PM
3838
April 07, 2009 05:58PM
8529
April 07, 2009 07:11PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.