We have MySQL Multi-Master replication setup between two servers ( A & B ). It has been working for a few years now and life is good.
The management tool in our office connects directly to Server A to perform updates and selects. As you can imagine this is not the fastest, especially because our office internet connection is no good.
So I would like to replicate the whole database on our office server but do not want to do this...
A -> B -> C -> A
because C will be a bottleneck for replication between B & A
Is their a way to
A -> B -> A AND C -> A -> C
I only see examples for creating loops of servers in MySQL. We can not migrate to a different database at this stage, nor immediately abandon the existing replication between A & B.