MySQL HA shootout at Percona Live UK
I'm looking at the schedule for Percona Live UK coming up in 2 weeks from now and realize there's quite a smorgasbord of High Availability talks. What's more interesting, I see that we will be presenting some opposite opinions for the audience to digest:
- Istvan Podor will talk about Keep your MySQL backend online no matter what, and the abstact reveals his tool of choice for that is MMM.
- Yoshinori Matsunobu will be presenting his recently released MHA scripts in MHA: Introducing automated MySQL Master Failover solution
- Yours truly will be presenting Choosing a MySQL Replication / High Availability Solution. If you've been reading my blog, you already know that I will advice the audience to choose a solution that is based on synchronous replication and also advising against clustering frameworks such as MMM and MHA. Fight, fight, fight...! To be fair to Istvan and Yoshinori, both of them will be presenting good results from actual production environments with a measured 99.99% uptime.
- Oli Sennhauser has a title similar to mine: Various MySQL High Availability Solutions. The abstract does not reveal if he has a personal opinion and if he will share it or take a neutral position. I know we at least share the same opinion of one clustering framework, Corosync :-)
If you look at talks given by vendors who also sponsor the conference, we also find quite a few talks from Tungsten, the keynote from Clustrix, a talk from Schooner, all of which are solely are mostly offering a high availability solution too. And we shouldn't forget two talks on MySQL Cluster.
Update: Interestingly, I did not catch that Codership is also presenting their Galera 1.0 release.
I've said for some time that I think replication and high availability (but also replication for scale-out) is the new hot topic in the MySQL world and perhaps database world in general. This is comparable to how everyone was concerned about scale-up performance circa 2008, when multi core hardware architectures became mainstream - we've since solved those scalability issues, now high availability and replication is the new focus. This is good, it's an area that is not easy to solve, but where we can do better.
We now have great performance. We have online backups with xtrabackup. Remember all the different and awkward ways you used to do backups? I'm confident we can also find a HA solution that is a pleasure to use and that won't lose data. The next generation of DBA's will not even be aware there used to be such a concept as "planned downtime" :-)
PS: I'm also giving a talk on Drizzle: Fixed in Drizzle: No more GOTCHA's. This is my favorite Drizzle talk that I've originally heard Stewart giving. My favorite Gotcha that isn't in Drizzle anymore are the .frm files. Come and tell me what your favorite is.
If you didn't buy a ticket already, you can use the Drizzle discount code DrizzlePLUK to save 40£.