MySQL High Availability Deep Dive: Pacemaker, DRBD, MySQL Replication, and more!

In this full-day tutorial, Florian and Yves explore the Pacemaker cluster stack, fully integrated with MySQL. We cover DRBD based and MySQL replication based cluster solutions, and combined configurations — all within one high availability framework.

In a 2-node high availability cluster, we walk you through setting up DRBD storage replication, Pacemaker high availability, and MySQL as a highly available, failure monitored, automatically recovering cluster resource. This is the simplest, quickest and easiest way to set up MySQL high availability in Pacemaker clusters, and can be accomplished by an experienced sysadmin in an hour or less. We then cover multi-node MySQL replication under Pacemaker management. With this, you can ensure quick and seamless failover with any MySQL storage engine, making use of MySQL replication for scale-out or redundancy. Finally, we dive into solutions combining high-availability with scale-out and disaster recovery. We show how to deploy mixed DRBD/MySQL replication configurations, with both transaction-safe high availability, and load-distributing scaleout. Attendees should bring Linux laptops with one of the following virtualization environments installed:

You will be provided with pre-installed virtual machine images. Required memory per virtual machine is approximately 512MB. For the full deployment count on running 4 virtual machines in parallel (total memory: 2GB). The virtual machines will run on any reasonably recent hardware. KVM/libvirt users should bring a laptop with virtualization CPU extensions (Intel VT or AMD SVM) available and enabled in the BIOS.

Track: 
Replication and High Availability Strategies
Experience level: 
Intermediate

Schedule info

Time slot: 
10 April 09:30 - 12:30
Room: 
Ballroom H

Schedule Info

10 April 09:30 - 12:30 @
Ballroom H

Speakers

Yves Trudeau's picture
Consultant, Percona

Yves is a Principal Consultant at Percona, specializing in MySQL High-Availability and scaling solutions. Prior to joining Percona in 2009, he worked as a senior consultant for MySQL AB and Sun Microsystems, assisting customers across North America with NDB Cluster and Heartbeat/DRBD technologies.

Yves holds a Ph.D. in Experimental Physics from Université de Sherbrooke. He lives in Québec, Canada with his wife and three daughters.

Florian Haas's picture
CEO, Principal Consultant, hastexo

Florian is a Linux high availability specialist, experienced technical consultant, seasoned training instructor, and technical writer. He is the principal author of the OpenStack High Availability Guide, was previously the principal author of the DRBD User's Guide, and has contributed numerous high availability articles to technical publications. He has previously spoken at Percona Live, the O'Reilly MySQL Conference & Expo, Linuxcon, linux.conf.au, OSCON and many other events.

Slides




Sponsored By