MySQL Forums
Forum List  »  Replication

Re: Slave to master replication
Posted by: Rick James
Date: April 08, 2009 10:56PM

Your question is ambiguous...

Many Masters, all replicating to one Slave -- No. (Ok, there are some kludgy ways, but yuck!)

One Master, many Slaves -- yes. I deal with a system with 18 slaves.
Be sure that each machine has a different server-id.
Network bandwidth could be an issue -- the binlog is copied to each of the slaves.

Cloning a slave to make yet another one:
1. stop existing slave
2. copy files from old slave to new
3. start both slaves
4. wait for replication to catch up before using them.

Master to Slave to Slave -- The middle guy is called a "relay"; it is both a master and a slave.

Master <-> Master -- "dual master".

Dual master + slaves -- yes.

There are other configurations, but they tend to be too problematical to mention.

Options: ReplyQuote


Subject
Views
Written By
Posted
3248
April 07, 2009 06:58PM
Re: Slave to master replication
2042
April 08, 2009 10:56PM


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.