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.