Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

My company is looking at a multi-data-centre solution for high-availability, fun, and profit.

We have businesses across the planet, with the need for MySQL database clustering solutions that can keep up with high-traffic over high-latency. Bandwidth isn't really an issue for us.

Could you please recommend a MySQL Database Cluster Architecture that is able to cope with high-latency networks. For instance, we have one Master at Sydney, AU, and another Master at New York, US - the latency between these two points can be up to a second or more.

We are currently using Percona Server 5.1, and we would like to stay this way, so I will place more value on answers that take this factor into consideration.

share|improve this question
    
You could look at Galera replication, Percona staff have been blogging about it regularly starting with mysqlperformanceblog.com/2011/07/14/… –  ssmusoke Mar 2 '12 at 11:48

1 Answer 1

For high-latency the main choice is between Percona XtraDB Cluster (Galera+InnoDB-based) or the new WAN replication in MySQL Cluster 7.2 (NDB-based). The downside of NDB is greatly increased complexity and application changes; it is NOT a drop-in replacement for your existing system. Percona XtraDB Cluster has only a few small differences, e.g. locking is pessimistic on the local node (as currently) but optimistic cluster-wide, so if there are conflicting changes on a remote node you won't find out until you commit. (If there are conflicting changes, the commit will fail and roll back; you can't break the cluster as you can with standard MySQL replication.)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.