Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Best Practices for MySQL High Availability in 2017

Best Practices for MySQL High Availability in 2017

 24 April - 9:30 AM - 12:30 PM @ Ballroom D
Experience level: 
Intermediate
Duration: 
3 hours tutorial
Tracks:
Developer
Topics:
MySQL
High Availability
Replication

Description

The MySQL world is full of tradeoffs, and choosing a high availability (HA) solution is no exception. This session aims to look at all of the alternatives in an unbiased nature. Preference is, of course, given to open source solutions. While the landscape will be covered, including but not limited to MySQL replication, MHA, DRBD, Tungsten Replicator, Galera Cluster, NDB Cluster, Vitess, etc., the focus of the talk will be what is recommended for today, and what to look out for. This will include deep-dive coverage of ProxySQL, semi-sync replication, Orchestrator, MySQL Router, and Galera Cluster variants like Percona XtraDB Cluster and MariaDB Galera Cluster (in pre-built environments due to time constraints). Note: Due to the focused nature of this edition of a popular tutorial, there will be some aspects of practicality to it, because there's no better way to grasp concepts. It is suggested that you bring a laptop that has the ability to run SSH. A familiarity with the command line will definitely be a bonus.

Speakers

Colin Charles's picture

Colin Charles

Chief Evangelist, Percona

Biography:

Colin Charles is the Chief Evangelist at Percona. He was previously on the founding team of MariaDB Server in 2009, and had worked at MySQL since 2005, and 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 APAC, and has spoken at many conferences.

Share this talk