Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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 3 servers A, B and C. What I want to do is replicate databases like this A->B->C, where A is replicating DB1 and DB2 to B and B is replicating those same databases to C, but I would also like to add an additional database from B that will replicated to C.

In other words, I want to replicate databases like this:

A (DB1, DB2) -> B (DB1, DB2) + DB3 -> C (DB1, DB2, DB3)

Is this possible?

share|improve this question

migrated from Mar 9 '12 at 12:30

This question came from our site for professional and enthusiast programmers.


ServerB will just replicate all databases to ServerC (ignoring replicate-ignore-db for now). There is no setting that limits ServerC to getting data that exists only on ServerA

That is, A(master) ->B (slave) is unrelated to B(master) -> C(slave) and A and C have no knowledge or replication dependency on each other

share|improve this answer
+1 for the simple "Yes" – RolandoMySQLDBA Mar 9 '12 at 16:28

Your Answer


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