UPDATE: Snack will be served from 18:30 to 19:00, talks will begin at 19:00, and we will have a break between ~20:00 and 20:30.
UPDATE: We regret to inform that Peter Zaitsev won't be able to attend this MeetUp due to traveling issues.
There will be three talks during this meeting, all from Percona Engineers (longer description below):
• InnoDB Architecture and Performance Optimisation (Dimitri Vanoverbeke)
• MySQL and OpenStack (Peter Boros)
• Fifteen tips to boost your Galera Cluster (Fred Descamps)
If you are planning to attend, please leave your real first and last name in the registration comment so we can give a list to reception to allow you to get in Booking.com office.
• InnoDB Architecture and Performance Optimisation:
InnoDB is the most commonly used Storage Engine for MySQL and Percona Server and is the focus for majority of storage engine development by MySQL and Percona Server teams.
In this talk, we will look at InnoDB Architecture, including new developments in MySQL 5.6 as well as Percona Server. We will explain how it should be used to get the the best performance from your application.
We will provide specific advice on server configuration, schema design, application architecture, and hardware choices.
• MySQL and OpenStack:
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 and determine if a synchronously-replication database cluster like Percona XtraDb Cluster is a good fit for certain OpenStack projects.
• Fifteen tips to boost your Galera Cluster:
During this presentation, we will show how to implement several stuff that will improve your day-to-day workload.
The points will cover topics like Point in Time Recovery, WAN replication with group segments, Avoiding SST when adding new Percona XtraDB Cluster node, ... the tips will be briefly explained to the audience and then put in practice.