MySQL High Availability Solutions

Lenz Grimmer presents at the 2009 OpenSQLCamp Europe, in conjunction with FrOSCon 2009.

From the official conference description at http://programm.froscon.org/2009/events/333.en.html

Best practices and commonly used HA setups for MySQL

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 over some best practices and commonly used HA setups for MySQL. The talk will cover the commonly used Open Source components and tools, with a focus on Linux and OpenSolaris. The session will also cover MySQL Cluster, the architecture and relationship to the MySQL Server.

MySQL is a popular open source relational database system (RDBMS) and 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. This talk will give an overview about different solutions and technologies available to make a MySQL Server system highly available. The session will start with a brief introduction to High Availability (HA), the terminology and general concepts involved. Afterwards, several 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.

Category:

Science & Technology

Tags:

• opensqlcamp
• froscon
• database
• sql
• lenz grimmer
• mysql
• HA
• high availability