High Availability

Continuent Databases MySQL

Controlled failover simplicity with MySQL

Ronald Bradford
September 19, 2012

As part of a recent engagement, I described the relative products to manage a MySQL pair (i.e. an Active/Passive MySQL masters configuration). This included the steps to undertake a controlled failover for supporting software maintenance using manual procedures.

Databases MySQL

Higher Availability (HA) starts with two database servers

Ronald Bradford
February 8, 2011

Many early startups that use a single server for all services or a single database server for their website talk about how they would like to achieve higher availability with MySQL.

Databases FOSDEM 2010 MySQL

Multi-Master Manager for MySQL – FOSDEM 2010

Ronald Bradford
February 7, 2010

The next presentation by Piotr Biel from Percona was on Multi-Master Manager for MySQL. The introduction included a discussion of the popular MySQL HA solutions including: MySQL Master-slave replication with failover MMM managed bi-directional replication Heartbeat/SAN Heartbeat/DRBD NDB Cluster A key problem that was clarified in the talk is the discussion of Multi-Master and this IS NOT master-master.