Re: Replication rings/maatkit (was: HA & Scalability w MySQL + SAN + VMWare)

2012-04-02 Thread Eric Bergen
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

Re: Replication rings/maatkit (was: HA & Scalability w MySQL + SAN + VMWare)

2012-04-02 Thread Wes Modes
> 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