Johnny Ljunggren wrote:
William Yu wrote:
What I'm not sure about though is what would happen with 2 slaves if
main goes down AND the connection between center 1 & 2 is also
disconnected. Others with more experience with the various
master/slave replication solutions might want to chime in now on how
it would work.
Well, this might be a problem, because there is no connection between
center 1 and 2, so they will basically live their own lives as long as
the connection to main center is down.
This would mean your system goes from Master-Slave to Multi-Master if
your main DB goes down. Roll your own replication time.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly