Visit the OpenStack Summit page for the latest news, registration and hotels.
View analytic
Tuesday, November 4 • 11:15 - 11:55
MySQL and OpenStack Deep Dive

Sign up or log in to save this to your schedule and see who's attending!

Like it or leave it, there's no disputing that MySQL is by far the most commonly used database in OpenStack deployments. Most folks know that there are a number of different flavors of MySQL -- standard MySQL, MariaDb, Percona XtraDb, MySQL Galera, Percona XtraDb Cluster, etc. However, there are a number of misconceptions and myths around the pros and cons of these flavors of MySQL.

In this talk, we hope to dispel some of these myths and give some clear information on what are the strengths and weaknesses of each of these flavors, what pitfalls to avoid when migrating between them, and what architectural information to take into account when planning your OpenStack MySQL database deployments. We will discuss replication topologies and techniques, and explain how the Galera Cluster variants differ from standard MySQL replication.

Finally, in the latter part of the session, we do a deep dive into MySQL database performance analysis. We will be analyzing the results of a Rally run showing a typical Nova workload, and demonstrate using pt-query-digest to determine if a synchronously-replication database cluster like Percona XtraDb Cluster is a good fit for certain OpenStack projects.


Peter Boros

Principal Architect, Percona
| Peter Boros joined Percona s European consulting team in May 2012. In the years before joining Percona he worked as a systems engineer and DBA at prominent companies including Sun Microsystems, where he specialized in performance tuning and was also a DBA at Hungary's largest... Read More →
avatar for Jay Pipes

Jay Pipes

Director of Upstream Engineering, Mirantis
Jay is Director of Upstream Engineering at Mirantis. He manages a team of senior engineers working on developing OpenStack projects in the community. Before Mirantis, he worked at AT&T, focusing on OpenStack development and operations. Previously, he was a Director of Engineering... Read More →

Tuesday November 4, 2014 11:15 - 11:55
Room 252 AB

Attendees (0)