High-Availability Mechanisms in MySQL

by Ari J. Flinkman.

With MySQL, the popular commercial open source relational database engine, been implemented several mechanisms to provide high availability and resistance to hardware failures. This paper looks at ways to build a fault-tolerant MySQL installation by creating a active/passive setup using either MySQL’s standard replication, shared storage or DRBD, the Distributed Replicated Block Device. The paper also takes a look at MySQL Cluster and NDB Storage Engine, which can be used to create a setup with multiple active server instances with redundant, distributed storage for data. [via]

http://www.cs.helsinki.fi/u/jplindst/ps/af-HA...