I suggest buying a copy of High Performance MySQL 3rd edition that
just came out. It has a whole chapter on HA that answers a lot of
these questions.
On Mon, Apr 2, 2012 at 6:14 PM, Wes Modes wrote:
>
>> Replication rings are possible but you must design your application to
>> take special care t
> Replication rings are possible but you must design your application to
> take special care to NOT update the same row in multiple nodes of the
> ring at the same time. This is even harder to design and code for than
> splitting writes/reads to master/slaves.
>
> Also the loss of one node of a re