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: 533
        
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:
- Multi-Master replication; 3 masters (one in each region), with the relevant 
auto_incrementoffsets, regularly backing up to S3. Or, - 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