HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

MySQL chain replication

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
mysqlreplicationchain

Problem

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?

Solution

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

Context

StackExchange Database Administrators Q#14695, answer score: 3

Revisions (0)

No revisions yet.