MySQL / MariaDB Sessions

Monday 9:00AM-12:00PM

@ Tutorial: Field Suite

Michael Coburn - Percona

This is a hands-on tutorial covering how to set up monitoring for MySQL database servers using the Percona Monitoring and Management (PMM) platform.

PMM is an open-source collection of tools for managing and monitoring MySQL and MongoDB performance. It provides thorough time-based analysis for database servers to ensure that they work as efficiently as possible.

You will learn about:
- The best practices on MySQL monitoring
- Metrics and time series
- Data collection, management and visualization tools
- Monitoring deployment
- How to use graphs to spot performance issues
- Query analytics
- Alerts
- Trending and capacity planning
- How to monitor HA

Please bring a laptop with the Virtualbox application.


MySQL / MariaDB
 Experience: Beginner
Operations

Monday 9:00AM-12:00PM

@ Tutorial: Goldsmith 1

Rene Cannao - ProxySQL

ProxySQL is an open source proxy for MySQL that is able to provide HA and high performance with no changes in the application, using several built-in features and integration with clustering software. Those are only a few of the features you'll learn about in this hands on tutorial.


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Developer, Operations

Monday 9:00AM-12:00PM

@ Tutorial: Goldsmith 3

Giuseppe Maxia - VMware

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. However, customizing in Docker is done differently, and we will see it in detail. This tutorial will cover :
* Operations from scratch, starting with running a single container;
* Steps and pitfalls of customising containers;
* Data management for safety and performance;
* Making several containers work together in complex topologies;
* Using containers as software transporters: mixing MySQL versions and operating systems.

Attendees to this tutorial will learn the basics of using MySQL containers stand-alone, in regular and group replication.


MySQL / MariaDB
 Experience: Intermediate
Developer

Monday 9:00AM-12:00PM

@ Tutorial: Pearse Boardroom

Dimitri Vanoverbeke - Percona, Tom Decooman - Percona

Do you want to get more familiar with how to become a MySQL DBA?

Are you a developer familiar with writing applications that use MySQL, but feel a bit limited on how to manage a MySQL database?

This full day tutorial will be mainly hands-on. We'll show some slides on each of the various topics presented, but the goal is to have YOU the student work in a MySQL environment as much as possible.

What will we cover? Almost every aspect of being a MySQL DBA, based on MySQL 5.7:
- We will install MySQL and configure the right privileges for your system
- Once we have a database running, we need to better understand what our database is doing. We will explain and look at the different possible diagnostics and monitoring options in MySQL
- We will troubleshoot issues
- Not losing any data is an important goal for a MySQL DBA, so we will discuss and try some of the different backup options
- We will clarify replication options
- We will look at how you check consistency in between your servers


MySQL / MariaDB
 Experience: Beginner
Operations

Monday 9:00AM-12:00PM

@ Tutorial: Swift Suite

Tibor Korocz - Percona, Alex Poritskiy - Percona

Never used Percona XtraDB Cluster before? Come join this half-day tutorial where we will introduce you to the concepts of a fully functional Percona XtraDB Cluster.

In this tutorial we are going to show you how can you install Percona XtraDB Cluster with ProxySQL and monitor it with PMM.

We will also cover topics like bootstrap, IST, SST, Certification, common-failure situations and online schema changes.

This entire tutorial is extremely hands on. We will supply instances for you to work with on your own laptop. You will be executing all the commands along with your instructors to gain first-hand experience.


MySQL / MariaDB
 Experience: Beginner
Developer, Operations

Monday 1:30PM-4:30PM

@ Tutorial: Goldsmith 1

Shlomi Noach - GitHub

Orchestrator is a MySQL topology manager and a failover solution, used in production on many large MySQL installments. It allows for detecting, querying and refactoring complex replication topologies, and provides reliable failure detection and intelligent recovery & promotion.

This tutorial walks through Orchestrator's setup, deployment and usage best practices. We will focus on major functionality points and share authoritative advice on practical production use.

Our cheat sheet covers:

- Detection: resolving, classification, pools, inspection.
- Topologies: Pseudo GTID, refactoring, querying for info.
- Failovers: configuration, promotion preferences, hooks, downtime, acknowledgements, planned failovers.
- Scripting: putting-it-all-together use case for automating failover tests.
- HA: Making orchestrator highly available, including recent consensus development.

This tutorial will be hands off, and open to discussion and examples by/for the attendees.


MySQL / MariaDB
 Experience: Intermediate
Developer

Monday 1:30PM-4:30PM

@ Tutorial: Goldsmith 2

Colin Charles - Percona, Ronald Bradford - Pythian

This tutorial provides a detailed roadmap for defining and implementing appropriate MySQL security for your data center and cloud environments. It will help you understand the options for and capabilities of authentication, encryption, key management and auditing in MySQL/Percona Server for MySQL/MariaDB/RDS and their variants.

This talk covers:

- A security primer
- The available ANSI and MySQL constructs
- The evolution of defaults in MySQL Versions
- Basic security hardening
- Reviewing authentication modules
- Better/Stronger/Harder passwords
- Encryption options for variants Percona Server for MySQL, MariaDB, MySQL Enterprise including LUKS, ezcrypt, gazzang
- Key management options
- Practical OS security (user accounts, sudo, iptables/ufw, SELinux/AppArmor)
- Why auditing is important
- Understanding the role of clouds, containers and compliance


MySQL / MariaDB
 Experience: Intermediate
Business / Case Studies, Operations

Monday 1:30PM-4:30PM

@ Tutorial: Goldsmith 3

Peter Zaitsev - Percona

InnoDB is the most commonly used storage engine for MySQL and Percona Server for MySQL. It is the focus of most of the storage engine development by the MySQL and Percona Server for MySQL development teams.

In this tutorial, we will look at the InnoDB architecture, including new feature developments for InnoDB in MySQL 5.7 and Percona Server for MySQL 5.7. We will explain how to use InnoDB in your database environment to get the best application performance and provide specific advice on server configuration, schema design, application architecture and hardware choices.

This tutorial has been updated from previous versions to cover new MySQL 5.7 and Percona Server for MySQL 5.7 InnoDB features.


MySQL / MariaDBOpen Source Databases
 Experience: Beginner
Operations

Monday 1:30PM-4:30PM

@ Tutorial: Pearse Boardroom

Dimitri Vanoverbeke - Percona, Tom Decooman - Percona

Do you want to get more familiar with how to become a MySQL DBA?

Are you a developer familiar with writing applications that use MySQL, but feel a bit limited on how to manage a MySQL database?

This full day tutorial will be mainly hands-on. We'll show some slides on each of the various topics presented, but the goal is to have YOU the student work in a MySQL environment as much as possible.

What will we cover? Almost every aspect of being a MySQL DBA, based on MySQL 5.7:
- We will install MySQL and configure the right privileges for your system
- Once we have a database running, we need to better understand what our database is doing. We will explain and look at the different possible diagnostics and monitoring options in MySQL
- We will troubleshoot issues
- Not losing any data is an important goal for a MySQL DBA, so we will discuss and try some of the different backup options
- We will clarify replication options
- We will look at how you check consistency in between your servers


MySQL / MariaDB
 Experience: Beginner
Operations

Monday 1:30PM-4:30PM

@ Tutorial: Swift Suite

Frederic Descamps - Oracle, Kenny Gryp - Percona

During this tutorial, attendees will get their hands on virtual machines and migrate standard Master - Slave architecture to the new MySQL InnoDB Cluster (native Group Replication) with minimal down time. After explaining what group replication is and how it works (the magic behind it), we will experiment with multiple use cases to understand MySQL Group Replication. We will also get the attendees more comfortable with this new technology.

During our experiments, we will try to:
- Cleanly stop a node
- Kill a node
- Re-join a node
- Produce conflicts and see how the cluster behaves
- Create data inconsistency
- Recover from full cluster outage

And finally, we will check how we can integrate MySQL InnoDB Cluster with external routing solutions like ProxySQL. We will also see how to use what the cluster exposes to performance_schema and sys schema to make the right choice.


MySQL / MariaDB
 Experience: Beginner
Operations

Monday 1:30PM-4:30PM

@ Tutorial: Swift Suite

Federico Razzoli - Catawiki

ORMs solve some really annoying problems. But do they really simplify things... in all situations? And, if they do, what is the price of hiding complexity from those who work with a database?

Let me show you what amazingly stupid things can happen under the hood, and how hard it can be to optimize a common query.


MySQL / MariaDB
 Experience: Beginner
Developer

Tuesday 11:20AM-12:10PM

@ Field Suite 1

Tyler Duzan - Percona

This talk is intended to give an overview of the feature differences between Percona Server for MySQL, Oracle MySQL Community Edition and MariaDB Server. We'll also dive into how some of these features are useful to a database developer or DBA in troubleshooting issues, increasing query performance and improving reliability.


MySQL / MariaDBOpen Source Databases
 Experience: Beginner
Developer, Business / Case Studies

Tuesday 11:20AM-12:10PM

@ Field Suite 2

Marco Tusa - Percona

ProxySQL is a very powerful platform that allows us to manipulate and manage our connections and queries in a simple but effective way.

Historically MySQL falls short in sharding capabilities. This significant area often caused developers to implement sharding at the application level, or DBAs/SAs to move on to another solution. ProxySQL has an elegant and simple solution that allows us to implement MySQL sharding capabilities without the need to perform significant (or any) changes in the code.

This brief presentation will illustrate how to successfully configure and use ProxySQL to perform sharding. We will cover very simple approaches based on connection user/IP/port, to complicated ones that see the need to read values inside queries.

Please note this presentation requires at least some basic ProxySQL knowledge.


MySQL / MariaDBOpen Source Databases
 Experience: Advanced
Developer, Business / Case Studies

Tuesday 11:20AM-12:10PM

@ Goldsmith 1

Giuseppe Maxia - VMware

MySQL 8.0 introduced roles: a new security and administrative feature that allows DBAs to simplify user management and increases security of multi-user environments. Using roles is easy, once you have digested all the documentation. For the uninitiated, though, the approach could be disappointing, and even give the feeling of not working at all. This quick demo will show some examples of how to deal with roles for several scenarios, how to assign roles to users, and how to use them effectively. Since there are several ways of assigning roles, the examples will cover both the roles granted as default and the cases where users can switch from one role to another within a session.


MySQL / MariaDB
 Experience: Beginner
Developer

Tuesday 11:20AM-12:10PM

@ Goldsmith 3

Rene Cannao - ProxySQL, 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. We will then describe multiple use case scenarios in which ProxySQL empowers large MySQL installations to provide HA with zero downtime, read/write split, query rewrite, sharding, query caching, and multiplexing using SSL across data centers.


MySQL / MariaDB
 Experience: Intermediate
Developer, Operations

Tuesday 11:20AM-12:10PM

@ Swift Suite 2

MC Brown - Continuent

Getting data out of your traditional database stores into a other database type can be problematic, especially if you want to do it in real-time.

Using Tungsten Replicator it's possible to move data from your existing Oracle and MySQL stores into a variety of targets, including Elasticsearch, Kafka and Hadoop.

In this session we'll look at the mechanics of each process and how to combine the core replication technology with filters and deployment models to enable complex data movement and concentration.


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Developer, Operations

Tuesday 12:20PM-1:10PM

@ Field Suite 1

Pep Pla - Pythian

Heterogeneous replication from MySQL to MongoDB has been available for a long time using Tungsten Replicator. In this session, we will explain (again) how to enable it and, what is more important and what you can and can't do with this feature. Also, some workarounds for common tasks will be discussed. Lastly, we will review some features missing that would be great to have and some ideas on how to implement them.

1. Introduction
- Origins of heterogeneous MySQL to MongoDB replication in tungsten
- MySQL vs. MongoDB
2. Create a lab using Vagrant
- Install all the stuff
- Check the environment
3. What you can do and what you can't do with Heterogeneous Replication
- Empty tables
- Tables with data
- Handling indexes
- Online schema changes
- De-normalizing (Document embedding)
4. Conclusions


MySQL / MariaDBMongoDB
 Experience: Intermediate
Developer, Business / Case Studies, Operations

Tuesday 12:20PM-1:10PM

@ Field Suite 2

Frederic Descamps - Oracle, Rene Cannao - ProxySQL

During this session we will cover the last development in ProxySQL to support regular expressions (RE2 and PCRE) and how we can use this strong technique in correlation with ProxySQL's query rules to anonymize live data quickly and transparently.

We will explain the mechanism and how to generate these rules quickly. We show live demo with all challenges we got from the Community and we finish the session by an interactive brainstorm testing queries from the audience.


MySQL / MariaDB
 Experience: Intermediate
Developer

Tuesday 12:20PM-1:10PM

@ Goldsmith 1

Guilhem Bichot - Oracle

Starting with version 8.0.1, MySQL supports Common Table Expressions (CTEs), non-recursive and recursive. This talk will introduce these objects, demonstrate how they can be leveraged to create more readable queries, and produce some reports which would otherwise require writing some iterative or recursive stored procedures. Tree-traversal examples will be covered. The implementation will also be briefly discussed.


MySQL / MariaDB
 Experience: Intermediate
Developer

Tuesday 12:20PM-1:10PM

@ Goldsmith 2

Sveta Smirnova - Percona

Replication is one of the features that made MySQL a popular RDBMS. It is easy to setup, and by default it allows read-write access on both the master and slave. It is also easily creates complicated deployments, such as circular replication.

By default, MySQL Replication is asymmetrical, but it has semi-sync replication plugin. Since version 5.7 it supports multi-master slaves. All these features implement a quick start, but there is also a huge risk of making the wrong decision.

In this session, I will demonstrate why one or another replication solution can fail with data loss or perform slowly. I will show methods that will help you to diagnose and resolve these issues.

This session uses built-in, then command-line tools, because knowledge of how they work is essential for effective troubleshooting.


MySQL / MariaDBOpen Source Databases
 Experience: Beginner
Business / Case Studies, Operations

Tuesday 12:20PM-1:10PM

@ Goldsmith 3

Michael Demmer - Slack

Slack is embarking on a major migration of the mysql infrastructure at the core of our service to use Vitess' flexible sharding and management instead of our simple application-based shard routing and manual administration. This effort is driven by the need for an architecture that scales to meet the growing demands of our largest customers and features under the pressure to maintain a stable and performant service that executes billions of MySQL transactions per hour. This talk will present the driving motivations behind the change, why Vitess won out as the best option, and how we went about laying the groundwork for the switch. Finally, we will discuss some challenges and surprises (both good and bad) found during our initial migration efforts, and suggest some ways in which the Vitess ecosystem can improve that will aid future migration efforts.


MySQL / MariaDBOpen Source Databases
 Experience: Advanced
Developer

Tuesday 12:20PM-1:10PM

@ Swift Suite 1

Kimberly Wilkins - ObjectRocket

MongoDB and Elasticsearch are both NoSQL "databases", or more correctly NoSQL data stores that are often compared and contrasted on a head-to-head basis.

But if comparing that way, one could easily miss out on the opportunity to use both together as individual and independent data stores that serve specific purposes to deliver the best overall solution for your application flow and performance needs.

In this talk, Kimberly will discuss the overall aspects of each technology, best use cases, the strengths and weaknesses of each, scaling, and provide examples for each with details for the underlying technology with architectural information and basic functioning of these two data stores.

Join her as she will offer opinions on the best times to use separately as independent data stores plus the chance to combine the two to get the absolute performance often needed by today's applications and the large amounts of data required.


MySQL / MariaDBMongoDBOpen Source Databases
 Experience: Intermediate
Developer, Operations

Tuesday 12:20PM-1:10PM

@ Swift Suite 2

Toshaan Bharvani - VanTosh

This presentation uses an abstracted use case from real life to show a migration from MySQL to MariaDB to Percona Server, and how the impact of these three different choices. It also shows how the three different databases reacted on the different platforms used, both in resource management and performance.


MySQL / MariaDB
 Experience: Intermediate
Security

Tuesday 2:20PM-3:10PM

@ Field Suite 1

Lixun Peng - Alibaba Cloud

Alibaba Cloud Database Kernel Team is supporting cloud database services in Alibaba Cloud Platform.
The MySQL in Cloud is big different with local MySQL. Usually, Cloud supports multi-tenancy. Then we need some features for that, such as:
1. Reset Connection: Let the connections can be re-used by different users.
2. Proxy Bypass IP: Let the Proxy can set the real client IP for connections.
3. Usergroup: SUPER/non-SUPER users are not enough, different users need different access poclies and resource quotas.
4. Implict Primary Key: It will let every tables have a default key internally for all engines, avoid the replication issues.
5. Flashback: It can let users can rollback the small mis-operations, instead of rollback all instance from a backup set.
And many other features for the Cloud cases.
In this session, you can know how Alibaba Cloud make MySQL is more suitable for the Cloud environment.


MySQL / MariaDB
 Experience: Intermediate
Developer

Tuesday 2:20PM-3:10PM

@ Field Suite 2

Michael Coburn - Percona

Come hear how performance improves 3x-10x in the latest Percona XtraDB Cluster 5.7, along with other security changes!

We will highlight:
* Dramatically improved OLTP concurrency throughput under multiple threads
* The value of disabling binlogs in PXC 5.7, and the tradeoffs to consider
* How Percona XtraDB Cluster performance compares to MariaDB Cluster and InnoDB Group Replication
* Integration with ProxySQL using proxysql-admin


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Developer, Business / Case Studies, Operations

Tuesday 2:20PM-3:10PM

@ Goldsmith 1

Ståle Deraas - Oracle

MySQL 8.0 implements atomic and crash-safe DDL. We will discuss how this affects behaviour of individual DDL statements, binlog and crash-safeness. We will also discuss the role of InnoDB as a data dictionary SE and a user tables SE, and touch upon requirements for writing a data dictionary SE for MySQL.
MySQL 8.0 implements I_S as views over dictionary tables stored in InnoDB. There are legacy features that require queries to SE. What is the impact of this, and how to make a compromise between updated and fast information.


MySQL / MariaDB
 Experience: Intermediate
Operations

Tuesday 2:20PM-3:10PM

@ Goldsmith 2

Vitor Oliveira - Oracle

MySQL Replication, in addition to bringing high-availability, is the foundation to build high-performance MySQL database systems. Using read scale-out and sharding one can design systems that go from the capacity of a single server to supporting the largest internet sites. But to design and operate high-performance, efficient, manageable and reliable deployments requires knowing the intricacies of the underlying technologies.

This session will provide insights on the main factors that affect the performance of Asynchronous Replication and Group Replication, and how to configure them to make the most out of the underlying computing system. It will also show the latest developments in MySQL 5.7 and 8.0, in areas spanning from group communication to the multi-threaded slave applier, and how effective they are in helping meet the performance requirements in terms of throughput, latency and durability to support the most demanding workload types.


MySQL / MariaDB
 Experience: Intermediate
Developer, Operations

Tuesday 2:20PM-3:10PM

@ Goldsmith 3

Marcelo Altmann - Percona, Mick Begley - IE Domain Registry

Databases play a key part of business infrastructure. To ensure you are prepared in case of a disaster, it is crucial to make sure your database and data are always available.

In this talk, DBA's and sysadmins will get exposed to the different types of backups.
- When a physical vs. logical backup is more appropriate
- How to make complete, partial and incremental backups and how to restore a single table from a physical backup
- Where backups should be stored
- How important it is to test the restoration of a backup
- How to include point-in-time-recovery on backup routines
- How to encrypt backups and why
- Which tools and techniques can be used to ensure the actual backup has consistent data

.IE (IEDR - Ireland's CCTLD) will share how they implement the topics above on their backup life-cycle.
By the end of this talk, the audience will have a clear picture of the key points of an actual backup.


MySQL / MariaDB
 Experience: Beginner
Business / Case Studies, Operations

Tuesday 2:20PM-3:10PM

@ Sky Suite 2

Daniel Lee - Grafana Labs

Grafana is the leading open-source graph and dashboard builder for visualizing time series and is a great tool for monitoring databases. Learn how to create dashboards and graphs in Grafana and how to use them to gain insight into the behaviour of your systems.

I will be demoing the new MySQL data source in Grafana that can be used to visualize any data that you have in your database and I will round off the session with a sneak peek of the upcoming major release - Grafana 5.0.0.


MySQL / MariaDBOpen Source Databases
 Experience: Beginner
Developer, Operations

Tuesday 2:20PM-3:10PM

@ Swift Suite 1

Tibor Korocz - Percona, Johan Nilsson - Verisure

The presentation will be a real-life study on how we utilize ProxySQL for connection pooling, database failover and load balancing the communication between our (third party) PHP-application and our master-master MySQL-cluster.

Also, we will show monitoring and statistics using Percona Monitoring and Management (PMM).

ProxySQL is a very powerful tool, with extended capabilities, and we want to show that it?s possible to utilize this to gain functionality (seamless database backend switch) and correct problems (applications missing connection pooling).


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Developer, Operations

Tuesday 2:20PM-3:10PM

@ Swift Suite 2

Peter Zaitsev - Percona

Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBA?s. The databases powering your applications need to be able to handle heavy traffic loads while remaining responsive and stable so that you can deliver an excellent user experience. Further, DBA?s are also expected to find cost-efficient means of solving these issues.

In this presentation, we will discuss how you can optimize and troubleshoot MySQL performance and demonstrate how Percona Monitoring and Management (PMM) enables you to solve these challenges using free and open source software. We will look at specific, common MySQL problems and review the essential components in PMM that allow you to diagnose and resolve them.


MySQL / MariaDB
 Experience: Beginner
Developer

Tuesday 3:20PM-4:10PM

@ Field Suite 1

Johannes Schlüter - Oracle, Rui Quelhas - Oracle

The last few years saw the advent of JavaScript in the server, and particularly Node.js. The dynamic functional nature of the language and the key philosophy of using schemaless literal objects or the corresponding JSON counterparts to express data-structures.

Matching this environment, MySQL recently introduced the MySQL Document Store, which enables using a regular MySQL database to manage schemaless data. This
presentation will describe the key concepts of the Document Store alongside the new X protocol that supports it and will show how to use the X DevAPI with the MySQL Node.js connector.


MySQL / MariaDB
 Experience: Beginner
Developer

Tuesday 3:20PM-4:10PM

@ Goldsmith 1

Bernt Johnsen - Oracle

MySQL 8.0 has got a whole new set of collations based on Unicode 9.0.0 and the utf8mb4 character set which is also the default character set in MySQL 8.0. This talk will present the new collations and what they bring into MySQL with regards to functionality and performance. The
talk will also look at the quirks and oddities you will have to think of when migrating your old MySQL 5.7 data to MySQL in order to take advantage of utf8mb4 and the new collations and cover topics:
- How to migrate to utf8mb4 from latin1, utf8 etc.
- Problems that might arise wrt. uniqueness, indexes etc.
- Pitfalls with character set and collation settings
- How to fix character set data that has for some reason a wrong encoding


MySQL / MariaDB
 Experience: Advanced
Developer, Operations

Tuesday 3:20PM-4:10PM

@ Goldsmith 2

Krzysztof Ksiazek - 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.

For which use cases do you use them and how well do they integrate in your environment? This session aims to give a solid grounding in load balancer technologies for MySQL and MariaDB.

We will review the main open-source options available: from application connectors (php-mysqlnd, jdbc), TCP reverse proxies (HAproxy, Keepalived, Nginx) and SQL-aware load balancers (MaxScale, ProxySQL, MySQL Router).

We will also look into the best practices for backend health checks to ensure load balanced connections are routed to the correct nodes in several MySQL clustering topologies. You'll gain a good understanding of how the different options compare, and enough knowledge to decide which ones to explore further.


MySQL / MariaDBOpen Source Databases
 Experience: Advanced
Operations

Tuesday 3:20PM-4:10PM

@ Goldsmith 3

Karoly Nagy - Dropbox

At Dropbox we treat data as sacred and we do everything to protect it well. We don't let a single transaction slide not even in case of a disaster. Our requirements to the backups are to be able to recover to any point in time without the slightest chance to lose any single transaction. This certainly brings new challenges to the backup infrastructure.

In this talk I will show you:

- How Dropbox backs up petabytes of data
- How is it possible to schedule thousands of independent backups jobs
- How binary logs are streamed from all hosts in a cluster, processed and merged into a single stream of events that is used for point in time recovery, that way the binary log stream is not affected by the issues of any single node


MySQL / MariaDB
 Experience: Intermediate
Operations

Tuesday 3:20PM-4:10PM

@ Swift Suite 1

Matthias Crauwels - Pythian

Currently we are in the process of rolling out of a new MySQL database layer on our own private cloud. We are the 2nd largest university in Belgium and we have a wide variety of applications running on MySQL. Some are in-house development that we can control and some are external or closed source tools we just have to run. We also opened up the infrastructure for employees and researchers within the university as a service to our internal community.

Our solution is build on virtual servers with network file systems and consists out of open source tools. We added a proxy layer based on ProxySQL to separate of our MySQL topology from the application layer. This because not all applications were build with read-write splitting capabilities or were too hard to reconfigure automatically. We implemented Orchestrator for topology management and introduced Percona Xtrabackup as our primary backup solution. The entire infrastructure is managed using puppet.


MySQL / MariaDB
 Experience: Beginner
Developer

Tuesday 3:20PM-4:10PM

@ Swift Suite 2

Yoshinori Matsunobu - Facebook

At Facebook, we open sourced MyRocks?Flash optimized, space and write efficient MySQL database engine. We are in the process of migrating our main MySQL databases?storing Facebook social graphs, massively sharded, low latency and automated services?from InnoDB to MyRocks. We have been very successful so far and have reduced database size by half.

Compared to deploying new database software into new or non-critical services, replacing existing stable database running on very critical services is much harder. You need to pay attention to lots of things, like how to migrate existing data without stopping or slowing down services, how to migrate within reasonable amount of time, and how to continuously verify not to corrupt any data.

In this session, the speaker will talk about MyRocks production deployment story. The following topics will be covered

- Overview of MySQL at Facebook
- What is MyRocks, and why we decided to create yet another database engine
- How Facebook MySQL SRE team collaborated with Engineering team
- How we prepared, executed and monitored InnoDB to MyRocks migration
- Lessons learned from the migration


MySQL / MariaDB
 Experience: Intermediate
Developer, Operations

Tuesday 4:30PM-5:20PM

@ Field Suite 1

Yura Sorokin - Percona

In this session we will discuss a new way of compressing data in the Percona XtraDB storage engine, compare it with existing InnoDB table compression from both a performance and data size point of view, and show how we can significantly increase the compression ratio using predefined dictionaries. This talk will cover the most typical usage scenarios for DBAs and reveal some design internals for developers.


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Developer, Operations

Tuesday 4:30PM-5:20PM

@ Field Suite 2

Julien Pivotto - Inuits, Kris Buytaert - Inuits

In this talk you will discover how you can fully manage your mysql setup in Puppet, including creation of users, databases, and even replication setup.

Puppet is one of the lead open source automation system, but somehow lots of people are still fragile about using it to manage their databases. We will expose how we are using it internally and for our customers, to maintain over time multiple identical mysql stacks accross environments.


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Operations

Tuesday 4:30PM-5:20PM

@ Goldsmith 1

Norvald Ryeng - Oracle

MySQL 8.0 is still in development, but we're already seeing a lot of improvement in GIS support. The latest development release comes with support for around 5000 different spatial reference systems, improved standard compliance and a lot of new functionality. How does it all
work, and how can it be used to build applications?

This talk starts with the basics of GIS and spatial data in MySQL: geometries, data types, functions, storage and indexes. We'll walk through a demo of how all the parts fit together to support a GIS web application. We'll also have a sneak peek into the future, including what you should do right now to prepare for the upgrade to MySQL 8.0.

Whether you're currently storing or planning to store spatial data in MySQL, this talk is for you. It covers the topics in a way that is accessible to both novices and more advanced GIS users.


MySQL / MariaDB
 Experience: Intermediate
Developer

Tuesday 4:30PM-5:20PM

@ Goldsmith 2

Nicolai Plum - Booking.com

Application databases start out small then later become large and complex. SQL performance and scheme management becomes too complex. Reliability suffers.

This talk will describe how to split a database schema in two, across separate replication chains to improve performance, scalability, and make database management easier.

It will cover the replication features used, the application code features needed to make the split invisible to end users, design choices for different reliability and uptime needs, how to do the split and how to tidy up. Real-life examples of good and bad will be included!


MySQL / MariaDB
 Experience: Intermediate
Developer, Operations

Tuesday 4:30PM-5:20PM

@ Goldsmith 3

Ronald Bradford - Pythian

In this presentation, we will discuss the migration of a rapidly growing production InnoDB system to TokuDB. This will include:

- Why TokuDB was chosen
- What features of TokuDB are used, and what features are not used
- Benchmarking and sizing evaluation used
- Additional dependencies and versions for software deployment
- Evaluating the backup options of Toku Hot Backup and LVM snapshots
- The impact of existing online alter statements procedures
- Balancing the memory configuration during migration to avoid OOM
- Tricks for a seamless production outage


MySQL / MariaDB
 Experience: Intermediate
Developer, Operations

Tuesday 4:30PM-5:20PM

@ Sky Suite 2

Guillaume Lefranc - Signal 18

The topic of this presentation is how to use ElasticSearch (ES) in order to speedup otherwise slow MySQL analytic queries. For this, we will look at an actual business case for a ride-sharing application, with the actual trip data stored in MySQL.

First, we will examine the ES requirements and explain how to import this data in ES and sync both databases.

Some specifics of ElasticSearch will be discussed, notably the Query DSL as well as the differences with MySQL and how to convert SQL queries to the ElasticSearch DSL.

Then, we will show how to design analytic queries in ES using aggregation and geolocalization, giving some real world examples (e.g. average earning per driver with pickups in the brooklyn area) and performance comparisons with the equivalent queries in MySQL.

Finally, we will discuss how to scale this implementation and make it highly available using ES clustering and sharding features.


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Business / Case Studies

Tuesday 4:30PM-5:20PM

@ Swift Suite 1

Pandikrishnan Gurusamy - Lazada South East Asia, Suresh Durgappa - Lazada South East Asia

Analyzing data to make crucial business decisions is vital for any company to survive in today's competitive market. Even more so when we consider the eCommerce industry. In every corner of the world, eCommerce companies are vying to capture the market share. As a result, companies are required to provide processes and infrastructure to allow data access to Business Intelligence and Development teams without compromising on regulatory requirements. To solve this problem, there is some commercially available software which encrypts data at rest by using key management within or outside the RDBMS. But we have been able to solve this problem innovatively by using triggers and a set of Python scripts which is free, masks data in real time, has simple to configure columns for masking and retains the usability of data after masking. We have developed a set of functions for each type of sensitive data that is used in various applications most commonly. We will also discuss pros and cons.


MySQL / MariaDB
 Experience: Intermediate
Security

Tuesday 5:25PM-5:50PM

@ Goldsmith 3

Michael Coburn - Percona

Did you know that Percona Monitoring and Management (PMM) ships with support for AWS RDS and Aurora out of the box? It does!

In this session we'll discuss:
* How to configure PMM (metrics and queries) against RDS and Aurora using an EC2 instance
* How to configure PMM against CloudWatch metrics
* Configuration parameters for RDS/Aurora/CloudWatch for maximum visibility in PMM
* Interesting components of the Metrics Monitor interface - what are the dashboards, what are the key graphs
* Overview of Query Analytics (QAN) against RDS/Aurora

On the roadmap for Q4 2017 is agent-less monitoring of RDS/Aurora and tighter CloudWatch/Prometheus integration!


MySQL / MariaDBOpen Source Databases
 Experience: Beginner
Developer, Business / Case Studies, Operations

Tuesday 5:25PM-5:50PM

@ Swift Suite 1

Guillaume Lefranc - Signal 18

In this demo, we will showcase how to perform master switching and failover using MySQL/MariaDB Replication Manager (MRM), a project to manage high availability in replicated database environments. We will review the various features of the MRM dashboard and how it integrates seamlessly with software such as ProxySQL to handle database traffic redirection. Finally we will describe several failover scenarios (in-sync, semi-sync, loss of data) and explain the approaches taken in MRM design in order to enforce best practices and achieve data consistency as much as possible.


MySQL / MariaDB
 Experience: Beginner
Operations

Tuesday 5:25PM-5:50PM

@ Swift Suite 2

Alex Yang - Facebook, Manuel Ung - Facebook

MyRocks is a Facebook project to integrate the RocksDB LSM storage engine into MySQL. In the past, we have covered basic functionality and performance benefits of MyRocks. In this talk, we'll cover new features of MyRocks necessary to meet our scaling requirements. We have reduced data load times for the storage engine and added better diagnostic capabilities. We have found and fixed various performance and data consistency issues in RocksDB.

We will also cover some new features that have been added to MyRocks over the past year.


MySQL / MariaDB
 Experience: Intermediate
Developer, Business / Case Studies

Tuesday 5:55PM-6:20PM

@ Field Suite 1

Dimitri Vanoverbeke - Percona

This talk will cover the Amazon Migration Tool. The talk will cover the possibilities, potential pitfalls prior to migrating and a high-level overview of its functionalities.


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Operations

Tuesday 5:55PM-6:20PM

@ Goldsmith 3

Michael Coburn - Percona

Using PMM, participate in a demonstration of how to leverage the combination of Query Analytics and Metrics Monitor when troubleshooting MySQL performance issues. We'll review the essential components of PMM, and use some of the most common cases of database slowness as examples of where to look and what to do.


MySQL / MariaDB
 Experience: Intermediate
Operations

Tuesday 5:55PM-6:20PM

@ Goldsmith 3

Renato Losio - Funambol

Lightning Talk: Amazon RDS offers the ability to modify a production MySQL database with the click of a button. But even if the "modify" button is very tempting, it can easily backfire with unintended consequences. The talk will cover simple scenarios where you should hold your nerve and clicking that button should be the last option you consider.


MySQL / MariaDB
 Experience: Beginner
Developer

Tuesday 5:55PM-6:20PM

@ Swift Suite 1

Narcis Pillao Figueras - Letgo

At Letgo we built a 100% fault tolerance platform using technologies such as ProxySQL + Consul + Replication Manager and Puppet.

The idea of this talk would be to explain how is possible to use a highly available platform using those described technologies. ProxySQL will route read and write queries, consul will ensure ProxySQL nodes are available and replication manager will handle failovers if the master goes down.

All those configurations will be deployed using a configuration manager such as Puppet.
After describing all the pieces, the idea is to run a live demonstration.


MySQL / MariaDB
 Experience: Intermediate
Operations

Tuesday -

@ Community Dinner Venue (The Mercantile Bar)

Renato Losio - Funambol

Lightning Talk: Amazon RDS offers the ability to modify a production MySQL database with the click of a button. But even if the "modify" button is very tempting, it can easily backfire with unintended consequences. The talk will cover simple scenarios where you should hold your nerve and clicking that button should be the last option you consider.


MySQL / MariaDB
 Experience: Beginner
Developer

Tuesday -

@ Community Dinner Venue (The Mercantile Bar)

Anirban Rahut - Facebook

We improved the connection rate of mysqld for both non-ssl and ssl-connections. We got a 2.5X improvement in improving connection rate non-SSL, and a 1.7X improvement on connection accept rate for SSL connections. We also ended up benchmarking and understanding the different SSL libraries and versions (OpenSSL 1.0, OpenSSL 1.1 and BoringSSL ). This improvement is deployed at scale at Facebook, and uses shared locking pattern to significantly reduce contention in mysqld global datastructures. It also uses advanced kernel features like SO_REUSEPORT to achieve these improvements. Implementing this has helped us handle connection surges in FB mysql tiers, more gracefully.


MySQL / MariaDB
 Experience: Intermediate
Operations

Tuesday -

@ Community Dinner Venue (The Mercantile Bar)

Philip Lacey - All n One Limited

My MSc thesis was to see what power could GPGPU bring to the processing of Db queries. The talk was just to see if there was anyone else out there who had considered using the power of Nvidia CUDA processing on the speed of response of a MySQL database.


MySQL / MariaDB
 Experience: Advanced
Developer, Business / Case Studies

Tuesday -

@ Community Dinner Venue (The Mercantile Bar)

Federico Razzoli - Catawiki

ORMs solve some really annoying problems. But do they really simplify things... in all situations? And, if they do, what is the price of hiding complexity from those who work with a database? Let me show you what amazingly stupid things can happen under the hood, and how hard it can be to optimize a common query.


MySQL / MariaDB
 Experience: Beginner
Developer

Tuesday -

@ Community Dinner Venue (The Mercantile Bar)

Toshaan Bharvani - VanTosh

This lighting talk is a technical pitch why you should use OpenPOWER for MySQL/MariaDB/Percona Server or even MongoDB and if you want PostgreSQL. It explains how a fully open source stack can be build from the machine upto the application. It will also say why POWER is a better architecture to run bigger databases.


MySQL / MariaDBOpen Source Databases
 Experience: Beginner
Developer, Operations

Tuesday -

@ Community Dinner Venue (The Mercantile Bar)

Balys Kriksciunas - Hostinger International

000webhost handles millions of user queries on close to million unique databases. In this talk we will present the obstacles we encountered on such scale. We will show why we moved away from the traditional webserver->dbserver to a more dynamic architecture using HAProxy, ProxySQL and MariaDB in LXC containers. We will present our model, query routing logic and the outcome from the collaboration with ProxySQL developer Rene.


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Developer, Operations

Tuesday -

@ Community Dinner Venue (The Mercantile Bar)

VISHAL GOEL - LAZADA

Few of the problems faced by DBA’s while running alters using pt-online-schema-change are as follows: Creation of Triggers on Slave may get blocked due to a long running select query Rename of old and new table on slave may get blocked due to a long running select query This utility aims to support DBA's with the above problems.


MySQL / MariaDB
 Experience: Intermediate
Operations

Wednesday 9:30AM-9:50AM

@ Goldsmith

Geir Høydalsvik - Oracle

Join Geir, Development Director for MySQL, to learn about the current state of MySQL development. Learn juicy tidbits of what to expect in MySQL 8.0, beyond what you see in the current Developer Milestone Releases!


MySQL / MariaDB
 Experience: Beginner
Business / Case Studies

Wednesday 11:20AM-12:10PM

@ Field Suite 1

Steve Shaw - Intel

When Intel launched the Xeon Scalable Processors in July 2017 the database benchmark used was HammerDB. HammerDB is an open source graphical benchmarking tool that enables the comparison between both open source and commercial databases on multiple platforms for OLTP and Query based workloads.
This presentation takes a real-world example of comparing MariaDB with a commercial database on Linux on Intel to show how to understand the benchmarks used and how to tune, configure and present findings on both performance and cost in a clear and concise way to evaluate the move to an open source database platform.
Based on the findings this session will share key learnings on current optimal platforms and storage technologies for database as well as the Intel focus on applying technologies to open source database acceleration such as FPGA and SSD and non-volatile memory.
Insights and previews will also be given into ongoing HammerDB development.


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Business / Case Studies

Wednesday 11:20AM-12:10PM

@ Field Suite 2

Frederic Descamps - Oracle, Jan Kneschke - Oracle

The new MySQL InnoDB Cluster is an out-of-the-box high availability (HA) solution for MySQL 5.7 and later. It combines the MySQL Server, the MySQL Router and the MySQL Shell for an easy-to-use, integrated solution. Setting up and managing the cluster with the new MySQL Shell puts HA into the hands of everybody, making it a core part of every MySQL installation This session starts with a FAQ covering myths and reality about MySQL InnoDB Cluster and then gives a high-level overview of the MySQL InnoDB Cluster feature set, shows how to use it and why there is no excuse to treat HA as an afterthought anymore.

We will also cover the concept of MySQL Group Replication and explain the best practices.

The session ends with an overview of the latest development.


MySQL / MariaDB
 Experience: Beginner
Developer, Business / Case Studies, Operations

Wednesday 11:20AM-12:10PM

@ Goldsmith 1

Sugu Sougoumarane - Google

Vitess (vitess.io) is a NewSQL system built as a sharding middleware for MySQL. It is especially suited for cloud deployment, and is beginning to gain traction in the community.

This session will focus on Vitess's new query handling features, its pluggable sharding scheme, and how the two work together seamlessly. There will be a demo at the end.


MySQL / MariaDB
 Experience: Intermediate
Developer, Operations

Wednesday 11:20AM-12:10PM

@ Goldsmith 3

Rohit Kumar (Pythian),Martin Arrieta - Pythian, Kedar Vaijanapurkar - Pythian

As service providers, one of our responsibilities is helping clients understand what causes contributed to a production downtime incident, and how to avoid (as much as possible) them from happening again. We do this with Incident Reports, and one common recommendation we make is to have a historical monitoring system in place. All our clients have point-in-time monitoring solutions in place, solutions that can alert them when a system is down or behaving in unacceptable ways. But historical monitoring is still not common, and we believe a lot of companies can benefit from deploying one of them.

In most cases, we have recommended Percona Monitoring and Management (PMM), as a good and Open Source solution for this problem. In this session, we will talk about the reasons why we recommend PMM as a way to prevent incidents, and also to investigate their possible causes when one has happpened.


MySQL / MariaDBMongoDBOpen Source Databases
 Experience: Intermediate
Developer, Operations

Wednesday 12:20PM-1:10PM

@ Goldsmith 1

Avraham Apelbaum - Wix.COM),Eyal Sorek (

Anyone looking for a high availability master-slave management solution for MySQL may come across ProxySQL and Orchestrator. This combination of products solves many problems, but still requires some manual labour when the configuration changes, when there is a network split and other scenarios. In this talk I will discuss the standard architecture, the solutions it provides and what it's missing. I will then share an automation solution developed at Wix, that solves those problems using Consul, to combine everything together.


MySQL / MariaDBOpen Source Databases
 Experience: Advanced
Operations

Wednesday 12:20PM-1:10PM

@ Goldsmith 2

Balazs Pocze - Gizmodo

We've migrated our platform (Kinja) from a datacenter-based approach to AWS, including migration of standalone MySQL hosts to RDS/Aurora.

I'd like to talk about our findings, what kind of problems we were hitting during this transition, giving you a hands-on experience about how you should change your thinking when you decide to move into a managed database service because it's a kind of different way compared to what you used to have.

I'd like to show you our best practices, I'd like to show some characteristics of Aurora, I'd like to show you a few of our utilties that we had to create to make daily operations possible.


MySQL / MariaDBOpen Source Databases
 Experience: Beginner
Business / Case Studies, Operations

Wednesday 12:20PM-1:10PM

@ Goldsmith 3

Matthew Lang - Continuent

The MySQL marketplace has quite a few High-Availability (HA) solutions such as Continuent Tungsten, Galera/XtraDB Cluster, various MySQL script/patch solutions, and RDS with multi-zone HA. Providing seamless, automatic failover with zero down-time maintenance in one data center can be challenging, but extending that same functionality across multiple sites in different continents truly makes that a difficult goal to achieve. Continuent has perfected various cluster solutions over the years and we have many customers running them in production, with more currently converting from Galera or RDS to our solutions.


MySQL / MariaDB
 Experience: Intermediate
Business / Case Studies, Operations

Wednesday 2:20PM-3:10PM

@ Field Suite 1

Vicentiu Ciorbaru - MariaDB Foundation

MariaDB has had its first 10.3 alpha release. This talk will go into what new features the MariaDB team has planned for this release.

Notable features include the "AS OF" syntax, as well as a subset of PL/SQL syntax that Oracle supports.


MySQL / MariaDBOpen Source Databases
 Experience: Beginner
troubleshooting

Wednesday 2:20PM-3:10PM

@ Field Suite 2

Ben Mildren - DigitalOcean

In this session we'll explore the different aspects of Consul and understand how it can be leveraged to provide opinionated Service Discovery and a distributed K/V store.

We will cover:
- Consul architecture & Service Discovery concepts
- Installation & configuration
- Service Registration
- Service Discovery using the Consul API & DNS
- K/V Store & ACL
- Using Consul with Prometheus
- Monitoring Consul

After this session you'll have had an overview to give you everything you need to get started with Consul, and should have a good understanding of how it can be leveraged in the context of software such as MySQL, ProxySQL, & Prometheus.


MySQL / MariaDB
 Experience: Beginner
Developer

Wednesday 2:20PM-3:10PM

@ Goldsmith 1

Walter Heck - OlinData

MySQL security is an interesting subject. In this session we'll show how to use Vault (https://www.vaultproject.io) to create a secrets store we can authenticate against using GitHub. On the other side, we'll demonstrate how we can use Vault to dynamically grant and revoke rights on a running MySQL Server. The end result allows us to not have to have a real MySQL user, but instead we first authenticate against Vault and then ask Vault for temporary access credentials to the MySQL instance of choice.


MySQL / MariaDB
 Experience: Intermediate
Developer

Wednesday 2:20PM-3:10PM

@ Goldsmith 2

Jonah Berquist - GitHub

gh-ost is a tool by GitHub that changes the paradigm of MySQL online schema changes, designed to overcome today's limitations and difficulties in online migrations. gh-ost is:

- Triggerless: no triggers placed;
- Pausable: can suspend master writes altogether
- Lightweight: makes a low impact on the master database
- Controllable: one can interact with an executing gh-ost process, get info and reconfigure parameters
- Testable: gh-ost allows for testable, safe, non obtrusive migrations in production
- Designed to allow for multiple concurrent migrations

In this session we will:

- Introduce gh-ost, explain the reasoning for developing a new tool
- Describe the underlying logic
- Compare with existing online schema change tools
- Show off extra perks that make gh-ost operations so friendly
- Discuss the roadmap and present with surprising implications

gh-ost is open sourced under the MIT license


MySQL / MariaDB
 Experience: Intermediate
Columnar

Wednesday 2:20PM-3:10PM

@ Goldsmith 3

Marco Nicosia - Pivotal Software

Planning to offer MySQL, but hoping to offer high availability or horizontal scaling capacity? Galera seems like the perfect fit! And it can be, so long as you and your developers are aware of several important hazards. Galera's documentation hints at these, but understanding the implications of their warnings can be tricky. This presentation will take you through the street signs you may encounter on the road to Galera, and how to interpret them quickly. This guide will help you choose the best path for you and your users.

The open source Platform as a Service project, Cloud Foundry, gives developers self-service access to relational databases. The open source project, cf-mysql, allows CF Operators reliable, automated access to slices of a MySQL Galera cluster. Over the years, we've experienced many different deployments under many different conditions. We'll share what we've learned, what worked, and what we'd do differently based on our use cases.


MySQL / MariaDB
 Experience: Intermediate
Business / Case Studies, Operations

Wednesday 2:20PM-3:10PM

@ Swift Suite 1

Dag Wanvik - Oracle

This presentation will highlight the new support for SQL window functions in MySQL 8.0: showing how they can be used to simplify and speed up analytical queries. The talk will first give a gentle introduction to basic concepts like partitions, frames and peers, explaining the differences between physical and logical frames. Then we move on to the two kinds of window functions and show their usage: SQL aggregates like COUNT and SUM used as window functions, as well as the dedicated window functions like ROW_NUMBER, NTILE, LEAD and more.

We will also cover some implementation aspects, particularly as they pertain to performance.

MySQL offers all the standard non-aggregate window functions, as well as most of the existing MySQL aggregate functions used as window functions. Window functions have the potential to greatly speed up many kinds of queries, and should be in the repertoire of all SQL developers.


MySQL / MariaDB
 Experience: Intermediate
Developer

Wednesday 3:20PM-4:10PM

@ Field Suite 1

Jason Anderson - Microsoft

Yes, you read that right. Microsoft loves MySQL and PostgreSQL! Azure Database for MySQL and PostgreSQL are Microsoft's first foray into OSS databases in Azure as fully-managed PaaS offerings. Come and learn about the platform architecture that powers Azure Database for MySQL and PostgreSQL in Azure and where Microsoft is headed next in this space!


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Developer

Wednesday 3:20PM-4:10PM

@ Field Suite 2

Marcelo Altmann - Percona, Marcos Albe - Percona

As a support engineer, everyday we get dozens of pt-stalk captures from our customers containing samples of iostat, vmstat, top, ps, SHOW ENGINE INNODB STATUS, SHOW PROCESSLIST and a multitude of other diagnostics outputs.

These are the tools of the trade for performance and troubleshooting, and we must learn to digest these outputs in an effective and systematic way to allow us to provide high quality service to a large volume of customers, and that is the knowledge we want to share through this presentation.

We will learn to setup, capture data, write plugins to trigger collection and to capture custom data, look at our systematic approach and learn what data to read first and how to unwind the tangled threads of pt-stalk.

By the end of this presentation you will have expert knowledge on how to capture diagnostic metrics at the right time and will have a generic approach to digest the captured data, allowing you to work on a large number of problems common to MySQL setups.


MySQL / MariaDB
 Experience: Beginner
Developer, Operations

Wednesday 3:20PM-4:10PM

@ Goldsmith 1

Vladimir Fedorkov - Astellar

ProxySQL is a widely used technology for MySQL load balancing and query routing. But there is one unique thing that makes it really outstanding: with ProxySQL you can connect to other databases using MySQL protocol.
We will walk through real customer's use cases where application utilized different database technologies using single MySQL protocol and and ProxySQL.


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Operations

Wednesday 3:20PM-4:10PM

@ Goldsmith 3

Shlomi Noach - GitHub, Tom Krouper - GitHub

The database team at GitHub is tasked with keeping the data available and with maintaining its integrity. Our infrastructure automates away much of our operation, but automation requires trust, and trust is gained by testing. This session highlights three examples of infrastructure testing automation that helps us sleep better at night:

- Backups: scheduling backups; making backup data accessible to our engineers; auto-restores and backup validation. What metrics and alerts we have in place.
- Failovers: how we continuously test our failover mechanism, orchestrator. How we setup a failover scenario, what defines a successful failover, how we automate away the cleanup. What we do in production.
- Schema migrations: how we ensure that gh-ost, our schema migration tool, which keeps rewriting our (and your!) data, does the right thing. How we test new branches in production without putting production data at risk.


MySQL / MariaDB
 Experience: Intermediate
Operations

Wednesday 4:30PM-4:55PM

@ Goldsmith 1

Marco Tusa - Percona

Percona XtraDB Cluster is a very robust, high performing and widely used solution that answers high availability needs. But it can be very challenging when deploying the cluster over a geographically dispersed area.

This presentation will briefly discuss the right approach to successfully deploying Percona XtraDB Cluster when in the need to cover multiple geographical sites, close and far.

- What is Percona XtraDB Cluster and what happens in a set of nodes during commit
- Clarify what geo-dispersed means
- What to keep in mind
- How to correctly measure metrics
- Use sync the right way (sync/async)
- Use tools like replication_manager


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Business / Case Studies, Operations

Wednesday 4:30PM-4:55PM

@ Goldsmith 2

Charity Majors - Honeycomb

"It's just a log, right?" How hard can it be, how can you possibly mess this up?

Wrong. Logs can impact your reliability, performance and quality of sleep in a million ways small and large. In this session we'll cover some of the lessons every engineer should know (and often learns the hard way), such as why good logging solutions are so expensive, why treating your logs as strings can be costly and dangerous, how logs can impact code efficiency and add/fix/change race conditions in your code. And what's the difference between a log line and an event, anyway?

We'll talk about how to craft a good, helpful log line or event and how to spot a bad one. We'll also talk about trends in debugging for complex systems, like the drive for structured logs/events and what comes next.


MySQL / MariaDBMongoDBOpen Source Databases
 Experience: Intermediate
Developer, Operations

Wednesday 4:30PM-4:55PM

@ Goldsmith 3

MING WANG - Grabtaxi Holdings Pte Ltd, Bei Lu - Grabtaxi Holdings Pte Ltd

This presentation gives a sharing about how we scale MySQL Databases in AWS. At Grab, we are using AWS RDS for most of our core services. In following talk, we will go through the different phases of our database infrastructure, the challenges and issues we have met at each phase, as well as the corresponding modification and optimisations we had for achieving better database performance to support various services that we have.


MySQL / MariaDB
 Experience: Intermediate
Developer

Wednesday 4:30PM-4:55PM

@ Sky Suite 2

Marcelo Altmann - Percona

Producing backups can be a complex task to achieve. Full backup, incremental backup, streaming backups, restore backups and encrypt backups. There are many factors to take into consideration.

This talk covers the best practices for backups using Percona XtraBackup.


MySQL / MariaDB
 Experience: Beginner
Business / Case Studies, Operations

Wednesday 4:30PM-4:55PM

@ Swift Suite 1

Andrew Moore - Digital Ocean

We all know those conference talks that bleat on about doing the right thing at the right time. This talk aims to reveal some of the anti-best practices to illustrate how some installations of MySQL are doomed from day 0. Infrastructure choice, queries and everything in between deserve special attention if you really want to fail fast.

This talk will cover:
- Picking the worst hardware you can for your mission critical database
- Schema over-engineering
- Query disasters
- Split brain scenarios we all want to see
- Replication disaster zone
- Highly available fails
- Accumulate these tips for instant dismissal


MySQL / MariaDBOpen Source Databases
 Experience: Beginner
Developer

Wednesday 4:30PM-4:55PM

@ Swift Suite 2

Tyler Duzan - Percona

This talk is intended to give a basic overview of the encryption requirements of several current compliance standards (EU GDPR, PCI DSS, HIPAAA/HITRUST, and SOC II TSP) and how the "at rest" encryption component can be met in a technology-agnostic way.

Have you wanted to deploy some cool new database to production, and simply can't make use of transparent data encryption? Come to this talk to find out how to use LUKS/dm-crypt to perform at-rest encryption, and where this fits into your overall compliance stance.


MySQL / MariaDBMongoDBOpen Source Databases
 Experience: Beginner
Business / Case Studies, Operations

Wednesday 4.55PM-5.20PM

@ Goldsmith 1

João Gramacho - Oracle, Sven Sandberg - Oracle

MySQL replication has been changing considerably over the years to meet the demands of highly volatile and very dynamic deployments of MySQL technology. The fact is that the MySQL that powered the LAMP stack is now powering the infrastructure of many of the popular cloud solutions out there. A common factor across them is replication, which has been often used for read scale-out. In fact, it has also deployed as the foundation to provision high availability and address disaster recovery when deployed across wide-area networks. Elasticity and redundancy are thus key properties in old as in new deployments.

The new replication features in MySQL 8 continue to match the requirements set in order to address web scale scenarios. All of this without compromising on features that are also important when deploying MySQL on premise or local clouds.

Come and learn about the new replication features in MySQL 8 that you will use to grow your business on top
of MySQL.


MySQL / MariaDB
 Experience: Advanced
Developer

Wednesday 4.55PM-5.20PM

@ Goldsmith 2

Frederic Descamps - Oracle, Jan Kneschke - Oracle

Starting with MySQL 5.7 a new Document Store feature has been introduced that makes working with JSON documents an integral part of the MySQL experience. The new X DevAPI gives MySQL users the best of both worlds - SQL and NoSQL - and allows an entirely new category of use cases for managing data. It is constantly evolving based on the community feedback and can be run on top of the brand new MySQL InnoDB Cluster feature. This session gives an overview of the Document Store possibilities and we will migrate data from MongoDB to MySQL and finally play with the data using NoSQL and SQL.


MySQL / MariaDBMongoDB
 Experience: Beginner
Developer

Wednesday 4.55PM-5.20PM

@ Goldsmith 3

Alexey Kopytov - ., Martin Arrieta - Pythian

sysbench is a benchmark tool that is quite ubiquitous in the MySQL community. It is used by both beginners and huge corporations alike as a quick way to evaluate general system performance, a universal measuring tool to compare configuration or code changes, server releases or server flavors, or as a part of QA process. This session will present new features provided by recent releases and explain how they can be used to create complex benchmark scenarios and collect performance metrics with a simple Lua API.

We will also run a live demo of some of the new sysbench features.


MySQL / MariaDB
 Experience: Beginner
Developer, Operations

Wednesday 4.55PM-5.20PM

@ Swift Suite 1

Mykola Marzhan - Percona

Percona Monitoring and Management (PMM) is a free and open-source solution for managing and monitoring MySQL and MongoDB performance. It provides accurate per-second analysis for MySQL and MongoDB servers, which allows you to tune the database as efficiently as possible.

This session will also be a review of internal PMM architecture, an overview of all components, and the communications between them.


MySQL / MariaDBMongoDB
 Experience: Intermediate
Operations

Percona Live

Percona Live Europe starts in:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA