7–9 November 2016: Conference & Tutorials
9–10 November 2016: Training
Amsterdam, The Netherlands

Best practices for MySQL high availability in 2016

Colin Charles (Percona)
11:30–13:00 Wednesday, 9/11/2016
Reimaging DevOps, security, and infrastructure Databases, DevOps G104/105 Audience level: Intermediate

Prerequisite knowledge

  • A working knowledge of MySQL replication

Materials or downloads needed in advance

  • A laptop (preferably Linux or OS X) capable of installing VMs or with MySQL Sandbox installed

What you'll learn

  • Learn current, modern high-availability options for MySQL

Description

The MySQL world is over 20 years old. In that time, many solutions have come and gone, many others have evolved, and even more have been created to provide solutions around high availability. Colin Charles explores all of these alternatives in an unbiased nature with a particular focus on open source solutions.

The MySQL world is full of trade-offs, and choosing a high-availability (HA) solution is no exception. How do you choose between MySQL replication, MHA, DRBD, Tungsten, and Galera Cluster? Do you integrate Pacemaker and Heartbeat like Percona Replication Manager? Is NDB Cluster right for your workload? The cloud brings even more fun as geographical redundancy is rolled in. There are now even “modern” tools to assist in automation like Orchestrator, Consul, MariaDB MaxScale, and MySQL Router.

Join Colin to figure out some of the answers as he walks you through MySQL HA options and when you will apply them.

Photo of Colin Charles

Colin Charles

Percona

Colin Charles is the chief evangelist at Percona. Previously, Colin was on the founding team of MariaDB Server, worked at MySQL, and worked actively on the Fedora and OpenOffice.org projects. Colin has been a MySQL user since 2000. He’s well known within open source communities in APAC and has spoken at many conferences.