SAPO Codebits 2009

Session Title

MySQL High Availability Solutions - Best practices and commonly used HA setups for MySQL

Abstract

The MySQL Server is a popular open source relational database system (RDBMS) and is widely used as the storage backend for dynamic web sites and applications. In many areas it has become a mission-critical component of the software stack, where downtime is not an option. There are many ways to ensure the availability of a MySQL Server and how to provide redundancy and fault-tolerance.

In this talk, Lenz will give an overview about some best practices and commonly used HA solutions and technologies for MySQL. The talk will cover the commonly used Open Source components and tools, primarily focusing on Linux and OpenSolaris.

The session will start with a brief introduction to High Availability (HA), the terminology and general concepts involved. Afterwards, several MySQL HA solutions and technologies will be introduced and explained, e.g. MySQL replication (and possible topologies), block device replication (DRBD), Shared storage/SAN, Linux-Heartbeat/Pacemaker, MySQL Cluster, MySQL Proxy and other clustering solutions like Sun Open HA Cluster or Red Hat Cluster Suite.

Language

English

Speakers

Lenz Grimmer

Lenz is a member of the MySQL Community Relations Team at Sun Microsystems. He lives in Hamburg, Germany and has worked for MySQL since April, 2002. Before joining the Community Relations team in December 2005, he was a member of the Release Engineering team that is in charge of creating the official release builds of the MySQL server. Prior to working for MySQL, Lenz was an engineer in the distribution development team of SuSE Linux in Nuremberg for four years. His first work experiences with LAMP environments date back to 1995, when he took his first job as a systems administrator and web developer for a small web company. He has a degree in Computer Science and has been involved in Linux and Open Source since 1994. In his spare time, Lenz enjoys hacking on open source software (e.g. maintaining his mylvmbackup tool or building RPM packages on the openSUSE Build Service), playing with his daughter Lena and spending time in the garden. (more)