High availability solutions for MySQL: An Overview and practical demo

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.