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.