RE: Advise on High Availability configuration

[Russell Horn]

Andrew Braithwaite wrote:

> Each slave keeps a heartbeat to the master and in the event of a failure,
> changes it's master to master2.

So how does this bit work? If one master falls over and slaves move to
master two, how do you rebuild master one without downtime? Don't the slaves
try and use Master 1 as soon as it's back online even though its data is out
of sync?

What if one of the slaves loses its heartbeat with master one and falls over
to master two when other slaves can still see master one. Don't you then
have inconsistencies in your data?

Russell.