Tutorial
MySQL High Availability Sprint: Launch the Pacemaker!

Sponsors
Clustrix Fusion-io Adfonic Continuent Facebook GenieDB Schooner Information Technology Severalnines SkySQL Booking.com Scalebase Couchbase FromDual Monty Program Sphinx Tokutek Devart Ivinco Virident Webyog Drizzle Apress New York PHP O'Reilly PalominoDB Stackware

October 24th, 2:00 PM
Newgate Suite

Abstract

In this tutorial, Florian will explore the quick and easy way to set up MySQL high availability. In a 2-node high availability cluster, Florian will 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.

But that's far from all that the Pacemaker stack has to offer for MySQL users. This tutorial will also touch upon 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, if time permits, we will also dive into Flashcache-backed MySQL under Pacemaker. Flashcache adds another layer of performance improvement, and we will show you how to use Flashcache for preheating storage caches in a failover environment.

Attendees should bring Linux laptops with KVM and libvirt installed, and will be provided with pre-installed virtual machine images. Required memory for the two virtual machines is approximately 1GB in total. The virtual machines will run on any reasonably recent hardware, but for best results, bring a laptop with virtualization CPU extensions (Intel VT or AMD SVM) available and enabled in the BIOS.

Speaker

Florian Haas

Florian Haas

CEO, Principal Consultant, Hastexo

Florian is a Linux high availability specialist, experienced technical consultant, seasoned training instructor, and technical writer. He frequently contributes to projects like DRBD, Pacemaker, Heartbeat, Corosync, and others. Florian is the principal author of the DRBD User's Guide, the Linux-HA User's guide and a number of Technical Guides on high availability, and a sought-after conference speaker.

 

]]> ]]>