Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the following setup:

3 servers, B1, B2, B3. A database from B1 is being replicated to B2. B1 is master and B2 is slave. Now, I want an another database from B2 to be replicated to B3.

I need to know if an already configured slave (for some other server) can act as master for a different server?

share|improve this question
up vote 2 down vote accepted

Yes, every server can be a master and a slave. The most basic example of this is having two servers that are both master and slaves for the other. The details are in the mysql manual. Your scenario is not that hard, because you are only going in one direction. Having the B3 server push data back to B1 would be more complex, but if all the other servers are just slaves and new data is basically coming in to B1 then it's not too difficult to manage.

share|improve this answer
Thanks. Figured it out. – Ankit Oct 17 '13 at 6:46

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.