MySQL Scale Wars - A New Hope & Replication Strikes Back
- 30 minute talk
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....
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.