Build resilient systems at scale
May 27–29, 2015 • Santa Clara, CA

Best practices for MySQL High Availability

Colin Charles (Percona)
11:00am–12:30pm Wednesday, 05/27/2015
Tutorial
Location: Ballroom AB
Tags: Databases
Average rating: ****.
(4.22, 9 ratings)

Prerequisite Knowledge

None. Be interested in using a database.

Description

The MariaDB/MySQL world is full of tradeoffs, and choosing a high availability (HA) solution is no exception. This session aims to look at all the alternatives in an unbiased way. Preference is of course only given to open source solutions.

How do you choose between: asynchronous/semi-synchronous/synchronous replication, MHA (MySQL high availability tools), DRBD, Tungsten Replicator, or Galera Cluster? Do you integrate Pacemaker and Heartbeat like Percona Replication Manager? The cloud brings even more fun, especially if you are dealing with a hybrid cloud and must think about geographical redundancy.

When you’ve decided on your solution, how do you provision and monitor these solutions?

This and more will be covered in a walkthrough of MySQL HA options and when to apply them.

Photo of Colin Charles

Colin Charles

Percona

Colin Charles works on MariaDB at MariaDB Corporation. He has been the chief evangelist for MariaDB since 2009, with work ranging from speaking engagements to consultancy and engineering work around MariaDB. He lives in Kuala Lumpur, Malaysia. Colin has worked at MySQL since 2005, and has been a MySQL user since 2000. Before joining MySQL, he worked actively on the Fedora and OpenOffice.org projects. He’s well known within open source communities in Asia and Australia, and has spoken at many conferences to boot.

Comments on this page are now closed.

Comments

Doug Thomas
05/27/2015 7:52am PDT

Thanks much, Colin. How may I obtain a copy of your slides?