Practical Linux Forum (Do, 04.05.2006)

MySQL Cluster - Surviving Desasters

von Kai Voigt (MySQL AB)

Donnerstag, 04.05.2006, Saal 11A, 11:00-12:00 Uhr

MySQL Cluster is a high performance and high availability database. It is available since version 4.1.5 and extends the existing single machine database architecture to a distributed system.

A MySQL Cluster consists of different types of nodes for storing data, handling SQL requests and to manage the Cluster topology. Each of these nodes can go offline for many reasons, for example power problems, disk trouble or maintenance purposes. Also, the network connection the nodes can fail.

All those possible scenarios will be discussed independantly and in combination. For each case, probabilities will be estimated and a Cluster configuration will be presented how to handle failures. Also, remaining risks will be discussed. The session will present best practice trade-offs between reasonable effort and still achieving 99.999% availability.

Über den Autor Kai Voigt:

MySQL AB, Sweden/Germany, since July 2005
Senior Instructor for MySQL classes

NetUSE AG, Kiel, Germany, January 1999 - June 2005
Deputy chief of software development department
Main focus: Apache/MySQL/PHP projects
UNIX Consulting
Main focus: Mail systems, LDAP infrastructure, privacy projects
In charge of trainee education

SH Online Dienst GmbH, Kiel, Germany, December 1997 - December 1998
Main focus: Developing Apache/MySQL/php applications