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.