Skip to main content

Best Practices for MySQL High Availability

Colin Charles (SkySQL Ab/MariaDB Foundation)
Databases & Datastores | Operations & System Administration
E143/144
Tutorial Please note: to attend, your registration must include Tutorials.
Average rating: ***..
(3.25, 4 ratings)

THIS TUTORIAL HAS REQUIREMENTS AND INSTRUCTIONS LISTED BELOW

How do you choose between: MySQL replication, MHA, DRBD, Tungsten, 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 into this.

  • Effectively understand the HA landscape around MySQL.
  • Effectively understand the HA landscape from an operating system perspective.
  • Choose between MySQL replication, MySQL High Availability (MHA), DRBD, Tungsten Replicator, and Galera Cluster.
  • Cover when MySQL Cluster (NDBCLUSTER) is right for use.
  • How to have HA in the cloud.
  • Sharding solutions, that are not limited to JetPants, Vitess or SPIDER.
  • MySQL 5.6 comes with new replication features that also come with utilities to help with orchestration of failover management – how do you take advantage of this?
  • How do you achieve geographical redundancy?
  • Understand Percona Replication Manager (PRM) and the Percona Toolkit for replication purposes.
  • The upcoming roadmap including MySQL Fabric.

The deep dives cover the MySQL HA landscape, MHA, Galera Cluster and Tungsten Replicator.

TUTORIAL REQUIREMENTS AND INSTRUCTIONS FOR ATTENDEES

* A Linux/Mac laptop is preferred with the ability to install MySQL Sandbox.
* This can also be done in a virtual machine (Virtualbox images will be provided).
* Access to AWS EC2 can be useful as well.

QUESTIONS for the speaker?: Use the “Leave a Comment or Question” section at the bottom to address them.

Photo of Colin Charles

Colin Charles

SkySQL Ab/MariaDB Foundation

Colin Charles works on MariaDB at SkySQL. He has been the Chief Evangelist for MariaDB since 2009, with work ranging from speaking engagements to consultancy and engineering works around MariaDB. He lives in Kuala Lumpur, Malaysia 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 Asia and Australia, and has spoken at many conferences to boot.

Leave a Comment or Question

Help us make this conference the best it can be for you. Have questions you'd like this speaker to address? Suggestions for issues that deserve extra attention? Feedback that you'd like to share with the speaker and other attendees?

Join the conversation here (requires login)

Comments

Picture of Colin Charles
07/08/2014 6:37pm PDT

Hi Sarkis – there will be virtual machines for you to use, so please install Virtualbox before attending. Windows and dev.mysql.com binaries are fine, the thing is replication requires running more than one instance, and that’s much easier with Sandbox (or in a VM). See you soon.

Picture of Sarkis Dallakian
07/08/2014 1:53pm PDT

I plan on bringing my Windows laptop and I wonder if I can use MySQL Community Server for Windows from http://dev.mysql.com/downloads/mysql/ instead of MySQL Sandbox. Looking forward to attending this tutorial and OSCON 2014.

Picture of Colin Charles
06/30/2014 11:12am PDT

Hi Glenn,

Once you have a vagrant setup, you will have a base OS (say Centos, Debian, etc.). MySQL Sandbox (http://mysqlsandbox.net/) is an easy install that you just have to point a tarball to.

So once your vagrant environment is up and running, you just have to do: make_sandbox mysql-ver.tar.gz

Yes, it does make assumptions of keeping thing in ~/sandboxes, and if you have two conflicting versions, you don’t just take the default – you edit the sandbox config file. But for most instances (and this tutorial) you don’t do that.

As to how much you’ll get out of this without a working MySQL Sandbox – a lot. I’m happy to help you fix this before the tutorial as well, if you somehow can’t get it to work.

Hope this helps.

Picture of Glenn Engstrand
06/21/2014 4:16pm PDT

I am having some trouble getting MySql Sandbox to work under vagrant. It seems to have a lot of assumptions about where things are. For example, it expects the mysql configuration files to be in the bin directory.

Do you have advise for running MySql Sandbox under vagrant?

How much will I be able to get out of this workshop without a working version of MySql Sandbox?