MySQL Scale Wars - A New Hope & Replication Strikes Back

  • 30 minute talk

Part I
For a few years we have been scaling our MySQL applications by splitting reads and writes onto separate servers. A master server handles the writes, while a fleet of slave servers take the read requests. But no longer!

Galera gives us high availability and scaling without the need to split reads and writes. It is easy, cheap and robust. Especially great if you don't control the application's source code.

Surely this will supercede the asynchronous replication feature? I will demonstrate how easy it is to setup a Galera cluster. Then we will take a node offline, and bring it back up to date, without the application needing to stop.

We will also talk about some of the limitations of Galera....

Part II
And just when we thought that Galera Synchronous replication would take over entirely,
we find that recent versions of MySQL and MariaDB have given us some great new asynchronous replication features. There are new reasons to consider old fashioned replication.

I will demonstrate the GUID, multi-thread, and multi-source replication features of MariaDB 10.
We'll discuss scenarios where this can scale larger than a Galera cluster can.
And finally, some scenarios where Galera and old fashioned replication can work well together.

About

Picnic Pete loves backups. Databases, file systems, photographs, whatever. He is an expert in MariaDB and MySQL, and does some coding in PHP on the side. You can find him at www.OpenQuery.com.au and peter[at]lock.id[dot]au.

The OSDC 2014 team is dedicated to providing a friendly, safe and welcoming conference environment for everyone. We have a code of conduct to clearly outline our expectations. Our goal is to create a safe and harassment-free conference experience for all involved, regardless of gender, sexual orientation, disability, ethnicity, religion, preferred operating system, programming language or text editor.