Take the 2-minute tour ×
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.

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 stackoverflow.com Mar 9 '12 at 12:30

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

add comment

1 Answer 1

Yes

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  
+1 for the simple "Yes" –  RolandoMySQLDBA Mar 9 '12 at 16:28
add comment

Your Answer

 
discard

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