[CentOS] MySQL max clustering package?
John R Pierce
pierce at hogranch.com
Wed Mar 17 06:24:34 UTC 2010
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.
More information about the CentOS