Wes Modes Re: Replication rings/maatkit (was: HA & Scalability w MySQL + SAN + VMWare)
Apr 02, 2012; 18:14
Wes Modes
Re: Replication rings/maatkit (was: HA & Scalability w MySQL + SAN + VMWare)
> 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 replication ring is not as easy to > recover from as simply promoting one slave to become the new master of > a replication tree (demoting the recovered former-master to become yet > another slave) as there may be pending events in the relay logs of the > lost node that have not yet been relayed to the downstream node. > > I may not have every answer, but I have seen nearly every kind of > failure. Everyone else is encouraged to add their views to the > discussion. >
Has anyone used maatkit or Percona to setup circular replication? How does it affect this system's reliability and robustness? Do the tools help to deal with fail over?
W.
-- Wes Modes Systems Designer, Developer, and Administrator University Library ITS University of California, Santa Cruz
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Apr 02
Eric Bergen Re: Replication rings/maatkit (was: HA & Scalability w MySQL + SAN + VMWare)
Apr 02, 2012; 18:28
Eric Bergen
Re: Replication rings/maatkit (was: HA & Scalability w MySQL + SAN + VMWare)
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!