Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Tutorials Schedule | Monday 3 October 2016

Monday 3 October 2016
8:00am to 9:00am
None

9:00am to 12:00pm

9:00am to 12:00pm
Matterhorn 1
  • Architecture/Design
  • MySQL
Peter Zaitsev
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 Tutorial, we will look at InnoDB Architecture, including new developments in MySQL 5.6 as well as Percona Server.
Optimization
9:00am to 12:00pm
Matterhorn 2
  • Architecture/Design
  • MySQL
Colin Charles
The MySQL world is full of tradeoffs and choosing a High Availability (HA) solution is no exception. This session aims to look at all of the alternatives in an unbiased nature. Preference is of course only given to opensource solutions. How do you choose between: MySQL replication, MHA, DRBD, Tungsten, Galera Cluster? Do you integrate Pacemaker and Heartbeat like Percona Replication Manager?
MySQL Tools and Techniques High Availability
9:00am to 12:00pm
Matterhorn 3
  • Scalability/Performance
  • MySQL
René Cannaò, Derek Downey, David Turner
Description Overview: There is a stigma attached to database proxies when it comes to MySQL. This tutorial hopes to blow away that stigma by showing you what can be done with a proxy designed from the ground up to be performant. That proxy is ProxySQL.
MySQL High Availability Sharding
9:00am to 12:00pm
Zürich 1
  • New and Trending Topics
  • MySQL
Giuseppe Maxia
Running database operations in containers is a slightly different proposition than running other services. MySQL, being designed - as the majority of services - for running in a dedicated host, needs some adjusting to fit in a container. Thanks to its configurability, we can deploy MySQL containers to fit our purposes, with just the right amount of customization.
MySQL Docker Tools and Techniques
9:00am to 12:00pm
Zürich 2
  • Scalability/Performance
  • MySQL
Brian Cain, Mark Filipi, Gillian Gunson
Overview: Many MySQL shops have made the transition from MySQL 5.5 to 5.6 in the last two years, but GTID (global transaction identifier) implementation has often been considered too difficult or risky a change. MySQL 5.7 is making GTID implementation easier, but it may not yet be clear why to convert.
MySQL Fundamentals Replication
9:00am to 12:00pm
St. Gallen
  • Operations and Management
  • MySQL
Krzysztof Książek
Someone came to your desk and said: “You seem to know MySQL, can you take care of our database? It looks like it needs some love”. Does that sound familiar? Lot’s of DBAs have gone that way. At the beginning, you need to learn a lot about MySQL and how to operate it. This hands-on tutorial is intended to help you navigate your way through the steps that lead to becoming a MySQL DBA.
MySQL Tools and Techniques Fundamentals
9:00am to 12:00pm
Lausanne
  • MongoDB
Art van Scheppingen
This hands-on tutorial is intended to help you navigate your way through the steps that lead to becoming a MongoDB DBA.
MongoDB Tools and Techniques Fundamentals
9:00am to 12:00pm
Winterthur
  • OSDBMS
  • Architecture/Design
Erik Witt, Felix Gessert
The unprecedented scale at which data is consumed and generated today has shown a large demand for scalable data management and given rise to non-relational, distributed "NoSQL" database systems.
NoSQL Sharding Replication
12:00pm to 1:30pm
None

1:30pm to 4:30pm

1:30pm to 4:30pm
Matterhorn 1
  • Scalability/Performance
  • MySQL
Sveta Smirnova
Performance Schema in MySQL is becoming more mature from version to version. In version 5.7 it includes extended lock instrumentation, memory usage statistics, new tables for server variables, first time ever instrumentation for user variables, prepared statements and stored routines. A lot! Amazing! And complicated! In this tutorial we will try all these new instruments out.
MySQL Tools and Techniques Metrics
1:30pm to 4:30pm
Matterhorn 2
  • New and Trending Topics
  • MySQL
Frédéric Descamps, Kenny Gryp
During this tutorial, attendees have their hands on virtual machines and migrate standard Master - Slave architecture to the new MySQL native Group Replication. After explaining briefly what is group replication and how this is important for MySQL HA architecture.
MySQL High Availability Replication
1:30pm to 4:30pm
Matterhorn 3
  • Scalability/Performance
  • MySQL
Yoshinori Matsunobu
At Facebook, we have worked on creating a new, flash-optimized transactional storage engine called MyRocks -- RocksDB storage engine for MySQL. InnoDB is great general purpose database and in many cases it fits the best. But there were cases where we wanted more space and write optimized database -- more efficient database on Flash.
MySQL
1:30pm to 4:30pm
Zürich 1
  • Architecture/Design
  • MySQL
Jaime Crespo
In this tutorial we will take Mediawiki, one of the most popular open-source wiki applications, and we will use it to discuss schema and scalability design problems we suffered on Wikipedia. We will discuss how they were solved (or how we plan to solve them). Forget about basic normalization theory or performance promises made by vendors in an ideal world.
MySQL PHP Optimization
1:30pm to 4:30pm
Zürich 2
  • MySQL
Peter Zaitsev, Alok Pathak, Krunal Bauskar
Percona XtraDB Cluster 5.7 is our brand new MySQL 5.7 compatible Galera-based high availability (HA) solution.
MySQL
1:30pm to 4:30pm
St. Gallen
  • Operations and Management
  • MySQL
Krzysztof Książek
Someone came to your desk and said: “You seem to know MySQL, can you take care of our database? It looks like it needs some love”. Does that sound familiar? Lot’s of DBAs have gone that way. At the beginning, you need to learn a lot about MySQL and how to operate it. This hands-on tutorial is intended to help you navigate your way through the steps that lead to becoming a MySQL DBA.
MySQL Tools and Techniques Fundamentals
1:30pm to 4:30pm
Lausanne
  • MongoDB
Kim Wilkins, David Murphy
This hands-on tutorial is the follow on of the morning session into more advanced topics for the DBA and we will be sharing best practices and tips on how to perform the most common activities. In this tutorial we are going to cover: Monitoring and trending for your MongoDB installation Performance problems - what to look for? Binary and logical backup What tools to use? Sharding
MongoDB Tools and Techniques Fundamentals
1:30pm to 4:30pm
Winterthur
  • OSDBMS
  • Operations and Management
Colin Charles
The MariaDB Server is loaded with lots of new features to increase data integration, performance, availability, scalability and orchestration. It is significantly “different enough” from MySQL that if you’re a DBA or developer, you’ll learn new things from this talk. This is a semi-hands-on tutorial.
MySQL