Summary of options

Method

Chapter(s)

Advantages

Disadvantages

MySQL Clustering

1-4
  • Scalable
  • High performance
  • Very high uptimes possible
  • Heavy RAM requirement
  • Relatively complicated
  • Heavy reliance on good network links

MySQL Replication

5
  • Simple
  • Highly available
  • Virtually no performance impact
  • Not scalable
  • Data can be lost in failure

MySQL Replication between MySQL Clusters

3

All the advantages of MySQL Clustering, with excellent disaster recovery
  • Extremely expensive
  • Manual failover

Shared-storage clustering

6

Excellent uptimes possible

  • Expensive storage required to minimize performance impact
  • Complexity, limited scalability

Block-level replication

7

Low cost

  • Performance impact
  • Scalability

Get High Availability MySQL Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial