Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 serverfault.com/questions/362776/… –  Baron Schwartz Mar 9 '12 at 14:30

2 Answers 2

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

 
discard

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.