[CentOS] MySQL max clustering package?

Wed Mar 17 05:24:34 UTC 2010
John R Pierce <pierce at hogranch.com>

Neil Aggarwal wrote:
> I agree. The built in cluster has too many limitations to
> be useful, but MySQL master-master replication gives a very
> good alternative to a true cluster.  We use it to deploy
> geographically redundant systems and it has worked very
> well for us.
>   


master-master replication has all kinds of inherent issues if you're 
concerned with data and transactional integrity.    its pretty hard to 
uncommitted a transaction some time after its been committed.

if its done fully safely, its incredibly slow, as you need global 
locks.  otherwise, you're playing russian roulette and relying on your 
data access patterns to inherently avoid conflicts.   if your problem 
space can be partitioned geographically, then its doable.