Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

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

Is is possible to have a setup where multiple mysql servers (containing different databases) are replicated in a single mysql slave server ?

If yes, how to do it ?

share|improve this question
There's some existing discussion of this at… – Baron Schwartz Mar 9 '12 at 14:30
up vote 1 down vote accepted

Using built-in MySQL replication, this is not possible. Some workarounds have been built that will periodically execute CHANGE MASTER to sync from one database, then execute CHANGE MASTER to sync from the other (I thought this was a maatkit tool, but I can't find it).

Tungsten Replicator allows you to do this also - multi-source replication.

share|improve this answer

If your design allows it, it may work, but i havent tested it Server A - master, and with replication-do-db you may pull databases from server B Server B - master Server C - slave of B

Worth a shot in a test environment

share|improve this answer

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.