MySQL Forums
Forum List  »  Replication

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.

Options: ReplyQuote

Written By
December 12, 2008 09:37AM
Re: Multiple masters to single slave
December 19, 2008 12:30AM
March 02, 2009 05:57PM
April 07, 2009 05:58PM
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.