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

October 3-5, 2016

Amsterdam, Netherlands

MySQL Sessions

The Percona Live Open Source Database Conference Europe 2016 is the premier event for the rich and diverse MySQL ecosystem in Europe.

MySQL is one of the most successful and widely-used open source database technologies ever. At Percona Live, you can learn about MySQL and its most popular variants (including Amazon RDS, MariaDB, Google CloudSQL, Percona Server and Percona XtraDB Cluster) directly from developers and some of the most well-known MySQL technology users.

Percona Live provides in-depth discussions for your MySQL high availability, IoT, cloud, big data and other changing business needs by tackling subjects such as analytics, architecture and design, security, operations, scalability and performance.

Below are the talks covering MySQL at this year’s conference.

10:20am to 10:45am
None
  • MySQL
  • MongoDB
Mark Callaghan (Facebook)
MySQL and MongoDB are moving fast to become great products for web-scale deployments, also known as sharded replica sets. MySQL was here before web-scale was a thing and focused on features we need. MongoDB is a more recent arrival with a focus on features that scale.
Other

11:20am to 12:10pm

11:20am to 12:10pm
Matterhorn 1
  • Development
  • MySQL
Philipp Krenn (Elastic)
Today’s applications are expected to provide powerful full-text search. But how does that work in general and how do I implement it on my site or in my application? Actually, this is not as hard as it sounds at first.
MySQL Fundamentals NoSQL
11:20am to 12:10pm
Matterhorn 2
  • Architecture/Design
  • MySQL
Krunal Bauskar (Percona)
Have you every thought to yourself: "I want to use Percona XtraDB Cluster, but is it suitable for my needs and can it handle my workloads?" Or: "As an active user of Percona XtraDB Cluster I wonder why my transactions keep failing, and will this workload run correctly with the software?" If the answer is yes, then this session is for you!
MySQL High Availability Replication
11:20am to 12:10pm
Zürich 1
  • New and Trending Topics
  • MySQL
Geir Høydalsvik (Oracle)
In this session, I will describe the new features that have all ready been announced for MySQL 8.0. In addition to Data Dictionnary and CTEs the session is covering: * Move to utf8(mb4) as MySQL's default character set * Language specific case insensitive collation for 21 languages (utf8) * Invisible index * Descending indexes * Improve usability of UUID and IPV6 manipulations * S
MySQL
11:20am to 12:10pm
Zürich 2
  • Scalability/Performance
  • MySQL
Ronald Bradford (EffectiveMySQL)
Learn how to use one simple advanced technique to make better MySQL indexes and improve your queries by 500% or more.
MySQL Optimization Tools and Techniques
11:20am to 12:10pm
St. Gallen
  • Development
  • MySQL
Galina Shalygina (Saint Petersburg State University), Sergei Petrunia (MariaDB Corporation)
MariaDB 10.2 introduces support for Common Table Expressions (CTEs). Both recursive and non-recursive CTEs are supported.
MySQL Focus Areas Tools and Techniques

12:20pm to 1:10pm

12:20pm to 1:10pm
Matterhorn 1
  • Architecture/Design
  • MySQL
Philipp Krenn (Elastic)
Most developers are familiar with relational databases and its query language, SQL. We know how to model our data so it can fit the relational paradigm and we know how to query this relational data using SQL. Elasticsearch is a document store with its own query DSL.
MySQL NoSQL
12:20pm to 1:10pm
Matterhorn 2
  • Scalability/Performance
  • MySQL
Peter Zaitsev (Percona)
In this talk, I will introduce Percona’s latest open source software tool: Percona Monitoring and Management (PMM). I will briefly discuss high-level aspects of monitoring we’ve found work well in practice at Percona, and then spend the rest of the time with an online demonstration of how to use this tool to identify common MySQL issues.
MySQL Monitoring
12:20pm to 1:10pm
Zürich 1
  • MySQL
Manyi Lu (Oracle)
There are substantial improvements in optimizer in MySQL 5.7 & MySQL 8.0. Most noticeably, users can now combine relational data with noSQL using the new JSON features. Functional indexes are now supported through generated columns. We also made DBAs’ life easier with explain on a running query and query rewrite plugin.
MySQL Optimization Fundamentals
12:20pm to 1:10pm
Zürich 2
  • Operations and Management
  • MySQL
Peter Boros (Dropbox), Viacheslav Bakhmutov (Dropbox)
Managing configuration for 1000s of database servers is hard, "hotfix" like set globals are easily forgotten, configuration rollouts can be complicated. At dropbox, instead of using puppet of chef (we use both), we wrote our own configuration handler for managing mysql configuration. This talk is about the overall architecture of the configuration generator we use.
MySQL Python Devops
12:20pm to 1:10pm
St. Gallen
  • MySQL
Bernd Erk (Icinga)
Icinga is a popular open source successor of Nagios that checks hosts and services, and notifies you of their statuses. But covering availability is not enough for a comprehensive database monitoring. On top of it you need metrics for performance and growth to deal with your scaling needs.
MySQL Monitoring
12:20pm to 1:10pm
Winterthur
  • PostgreSQL
  • MySQL
Dimitri Fontaine (Leboncoin)
Database migration projects are always articulated around the same steps, methodology and costs. At least when properly done. pgloader is meant to be disruptive in that market and offers to completely automate the “boring” parts.
MySQL Devops Tools and Techniques

2:10pm to 3:00pm

2:10pm to 3:00pm
Matterhorn 2
  • Architecture/Design
  • MySQL
Marco "The Grinch" Tusa (Percona)
ProxySQL is a flexible, fast and highly configurable piece of software that provides dramatic improvement to your cluster and high availability (HA) architecture. The presentation will discuss how to deploy ProxySQL in support of architectures using standard master/slave, Percona XtraDB Cluster/MySQL-Galera or MHA solutions. The presentation discusses details on: - ProxySQL host group -
MySQL High Availability
2:10pm to 3:00pm
Zürich 1
  • MySQL
Sunny Bains (Oracle)
The next version of MySQL will be a major release of new features and capabilities including a new data dictionary hosted in InnoDB. Learn all about the changes coming in the next version of InnoDB.
InnoDB Optimization Fundamentals
2:10pm to 3:00pm
Zürich 2
  • Architecture/Design
  • MySQL
Ronald Bradford (EffectiveMySQL)
Async, semi, and sync jump into the rink for your data management.
MySQL Data in the Cloud Replication
2:10pm to 3:00pm
Lausanne
  • Scalability/Performance
  • MySQL
Dimitri KRAVTCHUK (Oracle)
Come to have an informal discussion with all members of MySQL Team present during the Conference. Don't miss an occasion to get the info directly from the source! As well we're very curious to know what are your main issues today when using MySQL Server in your production environments. Our innovation comes directly from your feedback. Please, share!
MySQL Optimization Metrics
2:10pm to 3:00pm
Winterthur
  • PostgreSQL
  • MySQL
Evan Klitzke (Uber)
In 2013 Uber switched its relational database technology from MySQL 5.1 to Postgres 9.2. After running our business on Postgres for about two years we made the decision to migrate back to MySQL.
MySQL Other

3:10pm to 4:00pm

3:10pm to 4:00pm
Matterhorn 1
  • PostgreSQL
  • MySQL
Nicolai Plum (Booking.com)
This talk will discuss the different orthogonal axes that data storage systems can be scaled up along. Most storage system designs can grow successfully in one or more of read rate, write rate, data size and data complexity. They cannot grow in all of these directions; modern highly scalable storage systems are a compromise.
MySQL Optimization Fundamentals
3:10pm to 4:00pm
Matterhorn 2
  • Operations and Management
  • MySQL
Andrew Regner (Facebook)
MySQL is by far the most common choice among Facebook engineering teams when they are looking for a persistent data store for their product or application. Not all of this data goes into the "Facebook Graph" as not everything developed inside Facebook applies to a user or something they are sharing.
MySQL Tools and Techniques Sharding
3:10pm to 4:00pm
Zürich 1
  • MySQL
Luis Soares (Oracle)
The most recent MySQL release comes with a very exciting set of replication features.
MySQL Replication
3:10pm to 4:00pm
Lausanne
  • Scalability/Performance
  • MySQL
Laurynas Biveinis (Percona)
In this session we will discuss selected areas of InnoDB and XtraDB 5.7 internals that are mostly related to buffer pool management and flushing, from a performance and scalability point of view.
MySQL Optimization Programming

4:20pm to 5:10pm

4:20pm to 5:10pm
Matterhorn 2
  • New and Trending Topics
  • MySQL
Jean-François Gagné (Booking.com)
In the last 24 months, MySQL/MariaDB replication speed has improved a lot thanks to parallel replication. MySQL and MariaDB have different types of parallel replication; in this talk, I present the different implementations, with their limitations and the corresponding tuning parameters.
MySQL Tools and Techniques Replication
4:20pm to 5:10pm
Zürich 1
  • MySQL
Jan Kneschke (Oracle)
Starting with MySQL 5.7 it is now possible to use MySQL as a schemaless Document Store. In addition, using the new X DevAPI it is possible to work with Documents via either a CRUD interface or a traditional SQL interface. This presentation will describe the key concepts of the Document Store, including collections, X DevAPI and advances in the new X Protocol.
MySQL Programming NoSQL
4:20pm to 5:10pm
Zürich 2
  • Operations and Management
  • MySQL
Krzysztof Książek (Severalnines AB)
MySQL 5.7 has been around for a while now, and if you haven’t done so yet, it’s probably about time to start thinking about upgrading your database to the latest version. There are a few things you need to keep in mind when planning a MySQL upgrade, such as important changes between versions 5.6 and 5.7 as well as detailed testing that needs to precede any such upgrade process for instance.
MySQL Optimization High Availability
4:20pm to 5:10pm
St. Gallen
  • Scalability/Performance
  • MySQL
Alexey Rybak (Badoo), Tony Dovgal (Badoo)
This talk covers an open-source MySQL engine which is the core of real-time performance analytics in Badoo. Based on UDP-packets sent from back-end applications, PINBA is processing ~100K requests per second with just several MySQL instances, giving a simple SQL-interface to several pre-built real-time analytical reports.
MySQL Tools and Techniques Metrics
4:20pm to 5:10pm
Lausanne
  • Case Stories
  • MySQL
Ike Walker (Flite)
Native JSON support is new for MySQL in version 5.7, but how much should we be using it?
MySQL Tools and Techniques Programming

5:20pm to 6:10pm

5:20pm to 6:10pm
Matterhorn 1
  • Big Data
  • MySQL
Bosko Devetak (Booking.com), Rares Mirica (Booking.com)
At Booking.com we have complex MySQL installations, with very large tables in different servers. We’ve encountered the following question that we could not address with MySQL alone: How did some data/table look at a specific point in time? Answering this question is needed for many things, from observing trends in data changes and deriving insight, to fixing data after problems.
MySQL Hadoop Replication
5:20pm to 6:10pm
Matterhorn 2
  • MySQL
Junyi Lu (Facebook), Jesse Salomon (Facebook)
At Facebook, table schema changes are happening every second on our MySQL instances. To support the huge number of developers and instances we have, and to make the schema rollout process as seamless and stable as possible, we've built an automated system called AOSC (Automated Online Schema Change) to manage all of the relevant orchestration.
MySQL Python Devops
5:20pm to 6:10pm
Zürich 1
  • MySQL
Øystein Grøvlen (Oracle)
Common Table Expressions (sometimes referred to as WITH queries) are a new feature that will be available in MySQL 8.0. In their simplest form CTEs are a way of creating a view/temporary table for usage in a single query, and can help improve the readability of SQL code.
MySQL Fundamentals
5:20pm to 6:10pm
Zürich 2
  • Scalability/Performance
  • MySQL
Anthony Yeh (Google), Dan Rogart (YouTube)
Vitess is YouTube's solution for scaling MySQL horizontally through sharding, built as a general-purpose, open-source project. Now that Vitess 2.0 has reached general availability, we're moving beyond "getting started" guides and working with users to develop and document best practices for launching Vitess in their own production environments.
MySQL Devops Sharding
5:20pm to 6:10pm
St. Gallen
  • Scalability/Performance
  • MySQL
Daniel Black (IBM)
As new releases, bug fixes, security fixes and performance improvements are announced, users hope they are not accompanied by regressions.
MySQL Optimization Metrics
5:20pm to 6:10pm
Lausanne
  • MySQL
Josh Varner (SurveyMonkey), Emily Slocombe (SurveyMonkey), Mark Filipi (SurveyMonkey)
In this session we will review how the open-source database team at SurveyMonkey uses Ansible as both a configuration management and automation tool for our MySQL fleet.
MySQL Ansible Devops
10:25am to 10:50am
None
  • MySQL
Geir Høydalsvik (Oracle)
An Update on all things MySQL Development from Geir Hoydalsvik, Senior Software Development Director at Oracle.
MySQL

11:20am to 12:10pm

11:20am to 12:10pm
Matterhorn 2
  • MySQL
Shlomi Noach (GitHub), Tom Krouper (GitHub)
gh-ost is a new tool by GitHub which changes the paradigm of MySQL online schema changes, designed to overcome today's limitations and difficulties in online migrations.
MySQL Devops Tools and Techniques
11:20am to 12:10pm
Zürich 1
  • Operations and Management
  • MySQL
Krzysztof Książek (Severalnines AB)
Load balancing MySQL connections and queries using HAProxy has been popular in the past years. Recently however, we have seen the arrival of MaxScale, MySQL Router, ProxySQL and now also Nginx as a reverse proxy.
MySQL Tools and Techniques High Availability
11:20am to 12:10pm
Zürich 2
  • Security
  • MySQL
Ronald Bradford (EffectiveMySQL), Colin Charles (Percona)
This presentation will discuss the features of MySQL/MariaDB that when enabled and used improve the default usage of MySQL. Many cloud-based applications fail to - Using appropriate filesystem permissions - Using TLS/SSL for connections - Using TLS/SSL with MySQL replication - Using external authentication plugins (LDAP, PAM, Kerberos) - Encrypting all your data at rest - Monitoring you
MySQL Fundamentals Data in the Cloud
11:20am to 12:10pm
St. Gallen
  • OSDBMS
  • MySQL
Taco Scargo (RedHat), Karan Singh (Red Hat)
OpenStack is getting popularity among various industry segments for providing both internal and external IT services. Counting on OpenStack user survey, Ceph is the #1 and the most loved storage backend for providing persistent block storage service through OpenStack Cinder.
MySQL OpenStack Data in the Cloud
11:20am to 12:10pm
Lausanne
  • MySQL
Dmitry Lenev (Oracle)
A new data dictionary based on transactional tables is being developed for the MySQL server. This project is a huge step forward, improving many aspects of the server. The transactional data dictionary provides a new way of accessing meta data for use both by server and plug-in developers.
MySQL InnoDB Fundamentals

12:20pm to 1:10pm

12:20pm to 1:10pm
Matterhorn 2
  • MySQL
Teng Li (Facebook, Inc.), Santosh praneeth Banda (Facebook)
MySQL binary log management is one of the biggest challenges in MySQL clusters at the Facebook scale. Storing, indexing, retrieving and replaying binary logs is a complex task that we found ourselves re-implementing in our services over and over. To streamline our systems, we have designed a multi-purpose binlog management service called Binlog Server.
MySQL Replication
12:20pm to 1:10pm
Matterhorn 3
  • Security
  • MySQL
Jan Lindström (MariaDB Corporation)
Nearly everyone owns data of immense value: customer data, construction plans, recipes, product designs and other information. These data are stored in clear text on your storage media. Everyone with file system access is able to read and modify the data. If this data falls into the wrong hands this may result in serious consequences. With encryption you protect Data At Rest i.e.
MySQL AWS InnoDB
12:20pm to 1:10pm
Zürich 1
  • MySQL
René Cannaò (Self Employed), Alkin Tezuysal (Percona)
ProxySQL aims to be the most powerful proxy in the MySQL ecosystem. It is protocol aware and able to provide high availability (HA) and high performance with no changes in the application, using several built-in features and integration with clustering software. During this session we will quickly introduce its main features, so to better understand how it works.
MySQL Optimization Tools and Techniques
12:20pm to 1:10pm
St. Gallen
  • MySQL
Simon Mudd (booking.com)
MySQL 5.7.12 brings out a new interface to MySQL. This should have several benefits, and one use case is for the MySQL document store. There are APIs for several main supported languages. There is some documentation of how this new protocol works. If your language is not in those supported at the moment by Oracle is it possible to talk over the wire using the new protocol?
MySQL
12:20pm to 1:10pm
Lausanne
  • Scalability/Performance
  • MySQL
Daniël van Eeden (Booking.com)
The new multisource feature in MySQL 5.7 can be used together with transportable tablespaces (TTS) to do resharding. In this session I'll describe: - What multisource is - What TTS is and how it works - How XtraBackup and TTS can be combined - The problem which we tried to solve - Our approach - The issues we faced - how we might use this in the future to do similar operations.
MySQL Sharding

2:10pm to 2:35pm

2:10pm to 2:35pm
Zürich 1
  • Development
  • MySQL
Eric Herman (Booking.com)
As organizations grow, so does the data that is getting processed; sooner or later there is too much data to comfortably reside on a single database master. This talk will outline some of the options and trade-offs then present practical development and operational small-step techniques used at Booking.com for dividing one database master to two database masters without down-time.
MySQL
2:10pm to 2:35pm
Zürich 2
  • Security
  • MySQL
Otto Kekäläinen (MariaDB Foundation)
This talk explains how socket authentication in MariaDB/MySQL works and how it makes the life of system administrators easier when they can do all the maintenance as root, without the need for additional passwords. Life without extra passwords is also more secure, as there is less to leak or loose.
MySQL Docker Data in the Cloud
2:10pm to 2:35pm
St. Gallen
  • MySQL
  • MongoDB
Tim Vaillancourt (Percona)
This will be a demonstration and lecture on using Apache Spark to seamlessly query/join/etc. several different data stores. To showcase this flexibility, I will demo some operations on data stored in an SQL RDBMS (MySQL), a document database (MongoDB) and a key/value store (Redis) using SQL and Spark. Slides to come!
Spark Tools and Techniques Programming
2:10pm to 2:35pm
Lausanne
  • Scalability/Performance
  • MySQL
Bernhard Ocklin (Oracle)
MySQL Cluster combines the agility of web to deliver real-time apps with the reliability of Carrier-Grade communications services. Cluster is known to drive communication services for billions of mobile phone subscribers.
MySQL High Availability Sharding

2:40pm to 3:05pm

2:40pm to 3:05pm
Matterhorn 2
  • MySQL
Dimitri Vanoverbeke (Percona), Kenny Gryp (Percona)
Percona XtraBackup is a free, open source, complete online backup solution for all versions of Percona Server, MySQL® and MariaDB®.
MySQL
2:40pm to 3:05pm
Zürich 1
  • Scalability/Performance
  • MySQL
Seppo Jaakola (Codership)
This presentation will discuss recent development in the Galera Cluster for MySQL project. * Galera Cluster for MySQL 5.7 is currently in beta testing phase. The presentation will discuss the experiences with Galera Cluster 5.7 testing and list the main differences between 5.6 and 5.7 versions.
MySQL High Availability Replication
2:40pm to 3:05pm
Zürich 2
  • Big Data
  • MySQL
VAROQUI Stephane (MariaDB Corporation)
Querying multiple billions rows almost in real time are common requirements in many technical environment: web logs, monitoring, internet of things, back offices applications. We will explore an easy to deploy SPIDER sharding appliance that can compare in simplicity with MongoDB, Cassandra, Hadoop.
MySQL Docker Sharding
2:40pm to 3:05pm
St. Gallen
  • MySQL
  • MongoDB
Peter Zaitsev (Percona)
Demo on how to use Percona Monitoring and Management with MySQL and MongoDB
Web Services Metrics Monitoring
2:40pm to 3:05pm
Lausanne
  • MySQL
Colin Charles (Percona)
MySQL is a unique adult (now 21 years old) in many ways. It supports plugins. It supports storage engines. It is also owned by Oracle, thus birthing two branches of the popular opensource database: Percona Server and MariaDB Server. It also once spawned a fork: Drizzle.
MySQL Fundamentals

3:10pm to 3:35pm

3:10pm to 3:35pm
Matterhorn 2
  • Scalability/Performance
  • MySQL
Krunal Bauskar (Percona)
Often it is important to track and understand Percona XtraDB Cluster operations while executing a workload. Log files are one of the ways to track this information. Unfortunately, their capability is limited unless the user plans to use wsrep_debug. This method, however, can be too verbose and difficult to understand for end-users. Performance Schema helps solve this problem.
MySQL Tools and Techniques Monitoring
3:10pm to 3:35pm
Zürich 1
  • OSDBMS
  • MySQL
Abbas Ahmed (Rentalcars.com)
The shift to a Microservices oriented architecture for a large organization presents a challenge to manage scale, changes in replication topology and keeping the applications requiring to follow these changes pointing to the correct data sources for reading and writing data. I would like to present a design pattern for Micro Service data layer discovery that we have successfully deployed at Ren
MySQL Tools and Techniques Web Services
3:10pm to 3:35pm
Lausanne
  • OSDBMS
  • MySQL
Rachid Zarouali (SYNOLIA)
Percona Monitoring and Management is a very powerful set of tools. Built on top of prometheus and grafana, it comes bundled with major parts of a wide range monitoring system (not only database). As most of IT systems already have a monitoring platform, How to integrate PMM within an existing system ? what kind of customization should be made to ease the process ? How to stay as close as possi
MySQL Docker Monitoring

3:40pm to 4:05pm

3:40pm to 4:05pm
Matterhorn 2
  • MySQL
Dimitri Vanoverbeke (Percona), Kenny Gryp (Percona)
This presentation will present several Open Source tools which can provide DBA's, sysadmins and developers with additional information on the state and performance of their database while also facilitating the management of their database environment. We will present and discuss several following operational issues: - How to archive data from a large table while keeping an eye on the da
MySQL Data in the Cloud
3:40pm to 4:05pm
Zürich 2
  • MySQL
Alexey Kopytov (.)
The ARM architecture is getting good traction in the server market. In this session we will review pros and cons of using MySQL on ARM systems with many cores and multiple NUMA nodes, look at performance numbers, and discuss code contributions that were necessary to reach those performance levels.
MySQL Optimization
3:40pm to 4:05pm
Lausanne
  • Architecture/Design
  • MySQL
Taco Scargo (RedHat), Karan Singh (Red Hat)
We believe in hands-on experience and it becomes more awesome when it comes for FREE and easy to setup. Join us in this quick demo session about Red Hat Storage Test Drive platform where you can spin up all needed resources in AWS cloud.
MySQL Data in the Cloud

4:25pm to 5:15pm

4:25pm to 5:15pm
Matterhorn 2
  • Architecture/Design
  • MySQL
Colin Charles (Percona)
Lets learn from MySQL failures at scale, because we tie in the topic of High Availability, in where people are thinking about geographical redundancy, and even things like automatic failover. In the talk there will be case study material, e.g. where automatic failure caused Github to go offline, where Facebook doesn’t use fully automated failover but assisted failover, etc.
MySQL High Availability
4:25pm to 5:15pm
Matterhorn 3
  • MySQL
  • MongoDB
Igor Donchovski (Pythian), Martin Arrieta (Pythian)
What challenges are you facing when working with MongoDB? Are you a MySQL DBA trying to find the similarities between MySQL and MongoDB? This session will provide the analogous things between MySQL and MongoDB as well as what are the differences.
MySQL MongoDB Fundamentals
4:25pm to 5:15pm
Zürich 1
  • OSDBMS
  • MySQL
Federico Razzoli (Percona)
MariaDB 5.2 and MySQL 5.7 introduced virtual columns, with different implementations. Their features and limitations are similar, but not identical. The main difference is that only MySQL allows you to build an index on a non-persistent column. In this talk we'll present some use cases for virtual columns, such as query simplification and UNIQUE constraints based on an SQL expression.
MySQL Optimization
4:25pm to 5:15pm
Zürich 2
  • Operations and Management
  • MySQL
Divij Rajkumar (Facebook)
Routine backups are a key component of Facebook's MySQL Infrastructure. However, any presentation on disaster recovery will tell you that just taking backups isn't enough; they must also be routinely restored. At Facebook, we've built a system to continuously restore every backup we take so that everyone can go back to uploading cat pictures, even after a disaster event.
MySQL Python Data in the Cloud
4:25pm to 5:15pm
Lausanne
  • OSDBMS
  • MySQL
Ivan Zoratti (ScaleDB Inc.)
ScaleDB is a clustered, distributed storage engine for MariaDB, optimised for high volume, high velocity structured data.
MySQL Fundamentals Sharding
4:25pm to 5:15pm
Winterthur
  • MySQL
  • Analytics
Vicentiu-Marian Ciorbaru (MariaDB Foundation)
Window functions are a new feature of MariaDB 10.2. Window functions are a strong tool for solving analytic queries. They can allow for concise and clearer SQL code as well as faster running queries compared to regular SQL. This talk will go through an introduction of what window functions are, then focus on how various problems can be solved differently using window functions.
MySQL Optimization Programming

5:25pm to 6:15pm

5:25pm to 6:15pm
Matterhorn 2
  • MySQL
Mark Leith (MySQL @ Oracle)
The MySQL sys schema was integrated fully into MySQL Server from version 5.7.7 and has been improved in MySQL 8.0. Whether you are a DBA trying to determine where the resources are being used on your database instance and by whom, or a developer trying to figure out why your MySQL statements are running too slowly, the MySQL sys schema can help.
MySQL Tools and Techniques Metrics
5:25pm to 6:15pm
Zürich 1
  • Operations and Management
  • MySQL
Miklos Szel (Edmodo)
Scenario: You work as a consultant and a new client has just signed on. Their DBA left suddenly leaving nothing but some outdated documentation in their wiki.
MySQL Ansible Optimization
5:25pm to 6:15pm
Zürich 2
  • OSDBMS
  • MySQL
Jeremy Tinley (Etsy.com)
A look at how Etsy expanded MySQL capacity, reduced power and improved query speed by switching to SSD storage. The talk will include a short overview of the database architecture at Etsy and the rationale for making a hardware change.
MySQL Tools and Techniques Sharding
5:25pm to 6:15pm
St. Gallen
  • OSDBMS
  • MySQL
VAROQUI Stephane (MariaDB Corporation), Kayoko GOTO (Spider Mroonga Storage Engine ), Kentoku SHIBA (Spiral Arms., Ltd)
When your database is growing, you definitely need to think about other techniques like database sharding. SPIDER is a MariaDB Server / MySQL storage engine for database sharding. Using SPIDER, you can access your data efficiently across multiple database backends. In this time we will introduce the following things. 1. why SPIDER? what SPIDER can do for you? 2. when SPIDER is right for you?
MySQL Tools and Techniques Sharding
5:25pm to 6:15pm
Lausanne
  • Scalability/Performance
  • MySQL
Janis Griffin (SolarWinds, Inc)
Performance tuning can be complex. It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them.
MySQL Optimization Monitoring
5:25pm to 6:15pm
Winterthur
  • Operations and Management
  • MySQL
Pravin Pillai (Google)
In this session, we will provide an overview of Google Cloud Platform (GCP) followed by a deep dive on Google Cloud SQL, a fully managed database service for MySQL.
MySQL Other Data in the Cloud