[debian-mysql] Question about special MySQL Replication

[Denny Bortfeldt]

Hello all,

I hope you can answer my following question:

I've had 2 Servers with Master-Master Replication. Now I increase my server
size to 3.
I asked myself if it is possible to replication like this:

Update/Insert on Server  ------------- Replicate to

Server A ----> Server B & Server C
Server B ----> Server A & Server C
Server C ----> Server A & Server B

So if one update statement happen on one server, it will replicate to
TWO-Server and not only one.
I read about a lot of circulate replication - but what happen if one Server
will shut down? Then only 1 Server is "okay" and the other server won't get
the updates anymore - right?

Let's assume Server A is my Master Server where all updates happen:
Update on Server A --> Replicate to B --> B will Replicate to C

If B is now shutdown ('cause of hardware failure), then A can't Replicate
to B and therefore C won't get the Updates, right?

I really hope it's possible that 1 Server can replicate to more than 1
Master Server.


Thanks a lot in advance!!

Best Regards,
Denny
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20130727/53dc4f55/attachment.html>