Re: MySQL max clustering package?

[John R Pierce <pierce@xxxxxxxxxxxx>]

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.



_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos