MySQL high availability comparison: service versus dataFri, Mar 2, 2012 in Databases
When people ask me about high availability, I often suggest that it’s helpful to understand whether you’re most interested in service availability, data availability, or both. Of course, you want both – but if cost is an object, you may end up relaxing your requirements.
The typical example of an application that needs service availability but doesn’t have strong data availability requirements is something that’s ad-supported. Who cares if the last few comments on funny cat photos are lost? What’s important is that the users can see the photos, and the ads next to them.
On the other hand, if you’re selling something, it’s a big deal to lose records about orders or payments. In this case, if you can’t have both kinds of availability, you might prefer downtime over data loss.
Here’s a quick comparison of some MySQL high availability technologies. All opinions are mine alone:
|Technology||Data Availability||Service Availability||Notes|
|MySQL Semi-Sync Replication||Fair||Fair|||
|MySQL Cluster (NDB)||Good||Good|
|Percona XtraDB Cluster (Galera)||Good||Good|||
In a lot of cases the answer should really be “it depends.” For example, depending on how you set it up, the amount of service downtime you’ll experience during a DRBD failover can be quite long or quite short, due to factors such as the need to warm up the MySQL server before it’s actually usable. Hopefully this (admittedly broad-brush) overview is helpful in understanding the possibilities.
I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and many open-source tools for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB.