Q: I would like to make the following replication: 4 databases (A, B, C, D), all tables

• A -> B, C, D
• B -> A then, changes commited by this are to be replicated to C, D
• C -> A then, changes commited by this are to be replicated to B, D
• D -> A then, changes commited by this are to be replicated to B, C

How can I handle this kind of replication? By using different replication users?

---

A: There is similar scenarion in Employee example config database.

Create 6 replication schemas:

1. schemaid: 10, A->B (User: REPL_10)
2. schemaid: 20, A->C (User: REPL_20)
3. schemaid: 30, A->D (User: REPL_30)
4. schemaid: 11, B->A (User: REPL_10)
5. schemaid: 21, C->A (User: REPL_20)
6. schemaid: 31, D->A (User: REPL_30)

REPL_x users are important in centre (A). BCD may use the same user REPL (for connection to BCD).

You are right replication server distinguish according USER name (not to replicate back to the same database).