High Availability Solutions for MySQL

Databases are at the center of modern enterprise applications and store an organization’s most valuable assets including customer information, product information, order information and historical data. Plus, organizations rely on databases to run their business-critical applications. Hours or even minutes of downtime often result in significant amounts of lost revenue and unsatisfied customers. Therefore, making database applications highly available is a top priority for all organizations.

MySQL provides a number of options to make their database infrastructure highly available. Selecting which high availability solution is right for you will largely depend on how many “nines” of availability you require and the type of application you are deploying. MySQL provides you with the following options:

MySQL Replication

Using MySQL Replication, organizations can cost-effectively deliver a high availability solution. Master/Slave Replication enables operations to manually fail-over to another server in the event of a hardware or software problem. In addition, with MySQL replication, organizations can incrementally scale out their infrastructure to accommodate exponentially growing capacity demands. MySQL Replication ships out of the box and is used by some of the world’s most highly trafficked Web sites including YouTube, Yahoo!, flickr, Wikipedia and craigslist. Learn More »

DRBD for MySQL

DRBD for MySQL is a solution that combines MySQL, Linux Heartbeat, and Distributed Replicated Block Device (DRBD) so organizations can deliver a synchronously replicated high availability solution. Linux Heartbeat manages failover and DRBD synchronously propagates data to another node in an Active/Passive configuration. In the event the Active Server fails, Linux Heartbeat will promote the Passive node to an Active state, while DRBD will ensure the resynchronization of data after the failure. DRBD for MySQL is ideal for adding High Availability to new and existing MySQL applications. Learn More »

MySQL Cluster

MySQL Cluster enables organizations to deliver 5 Nines (99.999%) availability using a parallel server architecture with no single point of failure. MySQL Cluster is an in-memory storage engine that synchronously replicates data to all data nodes in the cluster. This results in sub-second response time and extremely fast failover. Data partitioning, fail-over, and recovery are all automatically handled by MySQL Cluster. MySQL Cluster is used by the world’s leading telecom organizations including Alcatel-Lucent, Nortel and Nokia. Learn More »