Dec 10, 2014
 Percona MySQL Webinar
  Peter Boros

There is no question that MySQL is by far the most commonly used database in OpenStack deployments. Most people know that there are a number of MySQL variants -- standard MySQL by Oracle, MariaDB, Percona Server, MySQL Galera, Percona XtraDB Cluster, etc. However, there are many misconceptions and myths around the pros and cons of these MySQL flavors.

This webinar will dispel some of these myths and give a clearer picture of 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 will take a deep dive into MySQL database performance analysis. We will analyze the results of a Rally run showing a typical Nova workload. In addition, we will 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.

Jay Pipes, Principal Technical Architect, Mirantis, will be joining Percona's Peter Boros for this presentation.

About the Author

Peter Boros

Peter joined the European consulting team in May 2012. Before joining Percona, among many other things, he worked at Sun Microsystems, specialized there in performance tuning and was a DBA at Hungary's largest social networking site. He also taught many Oracle University MySQL courses. He has been using and working with open source software from early 2000s. Peter's first and foremost professional interest is performance tuning. He currently lives in Herceghalom, Hungary with his wife and son.