Re: Replication

[Maxim Volkov]

An interesting idea Juergen. But, shouldn't be other way around?

A --> proxy --> B,C,D
B --> proxy --> A,C,D

In that case proxy works as query multiplier aka multiple masters replicating to multiple slaves.

Still concern would be proxy it self -- you are introducing redundancy into the system and don't have redundancy for mysql-proxy. You probably will still need double proxy running for every replication group.

Do you really need this complexity? Do you have high rate of writes with no immediate reads (because propagation will be still not instant and you probably would have to take extra steps in application to make sure that given ID is present on a given server)? When you have to scale how you introduce an extra element into the chain?

maxim