MySQL-Cluster or Multi-Master for production? Performance issues?

Posted by Phillip Oldham on Server Fault See other posts from Server Fault or by Phillip Oldham
Published on 2011-01-31T16:04:37Z Indexed on 2012/04/10 17:32 UTC
Read the original article Hit count: 446

We are expanding our network of webservers on EC2 to a number of different regions and currently use master/slave replication. We've found that over the past couple of months our slave has stopped replicating a number of times which required us to clear the db and initialise the replication again.

As we're now looking to have servers in 3 different regions we're a little concerned about these MySQL replication errors. We believe they're due to auto_increment values, so we're considering a number of approaches to quell these errors and stabilise replication:

  1. Multi-Master replication; 3 masters (one in each region), with the relevant auto_increment offsets, regularly backing up to S3. Or,
  2. MySQL-Cluster; 3 nodes (one in each region) with a separate management node which will also aggregate logs and statistics.

After investigating it seems they both have down-sides (replication errors for the former, performance issues for the latter).

We believe the cluster approach would allow us to manage and add new nodes more easily than the Multi-Master route, and would reduce/eliminate the replication issues we're currently seeing. But performance is a priority.

Are the performance issues of MySQL-Cluster as bad as people say?

© Server Fault or respective owner

Related posts about mysql

Related posts about mysql-replication