MySQL Replication: Pros and Cons

Most mission-critical databases are deployed across multiple datacenters, both for disaster recovery and for load distribution. Maintaining consistency across two datacenters and writing scripts for failover and recovery has always been a real pain in MySQL. Slave lag is another big problem.

In this session we’ll discuss the pros and cons of different types of replication in MySQL and the tradeoffs associated with each.

Key topics discussed:

• The use of synchronous replication of InnoDB to eliminate data loss and to provide cluster-wide data consistency.
• The use of high parallelism and granular concurrency control with synchronous replication to fully exploit commodity servers and storage to maximize performance, resulting in huge consolidation.
• Extending base synchronous clusters with tightly coupled, parallel asynchronous replication to achieve auto-failover and high consistency across geographically dispersed data centers.