Article for conference booklet:
MySQL is a popular open source database system and often used as the backend for Drupal installations. This session will give an overview about different solutions and technologies available to make a MySQL Server system highly available. After the theoretical part, a practical demonstration of a HA cluster for Drupal will be performed. With the help of Red Hat Cluster Suite, we will build a HA solution using MySQL replication. If time permits, we will then extend the solution to use shared storage device. The session will start by giving an Introduction to High Availability, Terminology and general concepts involved. Afterwards, severeral MySQL HA solutions will be introduced and explained, e.g. Replication (and possible Topologies), Linux-Heartbeat, Block device replication (DRBD), Shared storage/SAN, MySQL Cluster, MySQL Proxy, Sun Open HA Cluster and Red Hat Cluster Suite. Following the theoretical part from Lenz, Jakob will perform a practical demonstration of how to set up a HA system for Drupal and MySQL using RHEL Cluster Suite. Attendees will gain more insight into how MySQL Server setups can be made more fault-tolerant and how to ensure high availability. The practical part will provide an insight into how the RHEL Cluster Suite works, what you need to build a High Availability solution and configuration basics.
Bios for conference booklet:
Lenz Grimmer works for the Database Group at Sun Microsystems as a MySQL Community Relations Manager. He joined MySQL in 2002 as a release engineer, being in charge of building and publishing the official releases of the MySQL Server for the various supported platforms. Prior to joining MySQL, he was a developer in the SuSE Linux Distribution development team at SuSE Linux AG in Nuremberg, Germany. Lenz started using and advocating for Linux and Open Source Software in 1995, when he first got in touch with it during his computer science studies at the Berufsakademie in Mannheim, Germany.