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

October 3-5, 2016

Amsterdam, Netherlands

Schedule - Day 2 | Wednesday 5 October 2016

Wednesday 5 October 2016
8:15am to 9:15am
None
9:15am to 9:25am
None
  • OSDBMS
Jim Doherty
Welcoming Remarks
Other
9:30am to 9:55am
None
  • OSDBMS
Peter Zaitsev
Percona Contributions to the Open Source Database Ecosystem
MySQL MongoDB Other
10:00am to 10:20am
None
  • OSDBMS
Otto Kekäläinen
In recent years MariaDB has gained a lot of interest and we are seeing it being adopted by many well known entities like Wikipedia, Alibaba, Google and Amazon. It has been embraced by most Linux distributions and other open source projects.
Other
10:25am to 10:50am
None
  • MySQL
Geir Høydalsvik
An Update on all things MySQL Development from Geir Hoydalsvik, Senior Software Development Director at Oracle.
MySQL
10:50am to 11:20am
None

11:20am to 12:10pm

11:20am to 12:10pm
Matterhorn 1
  • OSDBMS
  • Analytics
Victor Tarnavsky
Yandex team has built one of the best databases for analytics. It's fast, capable for storing petabytes of data and supports SQL. Now it goes open-source. During the session we will review ClickHouse most interesting features and advantages.
Metrics Business Intelligence
11:20am to 12:10pm
Matterhorn 2
  • MySQL
Shlomi Noach, Tom Krouper
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
Matterhorn 3
  • Operations and Management
  • MongoDB
Pavel Trukhanov
Main mission for every DB instance is to execute commands and queries — that is what databases are for. To know if a database is behaving well means to know if your app is getting correct responses for queries and in time.
MongoDB Metrics Monitoring
11:20am to 12:10pm
Zürich 1
  • Operations and Management
  • MySQL
Krzysztof Książek
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, Colin Charles
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, Karan Singh
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
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
11:20am to 12:10pm
Winterthur
  • Operations and Management
  • MongoDB
Art van Scheppingen
MongoDB is one of the most popular NoSQL solutions and as MongoDB is Open Source, any developer can contribute to the product and anyone can use it. The business model of the company behind MongoDB is to sell premium support and administration tools to maintain and monitor MongoDB. As an alternative there are (open source) solutions that could make your life as a DBA easier.
MongoDB Tools and Techniques Fundamentals

12:20pm to 1:10pm

12:20pm to 1:10pm
Matterhorn 1
  • OSDBMS
  • Scalability/Performance
Christos Erotocritou
Join Christos Erotocritou, Principal Solution Architect EMEA at GridGain Systems to learn how to boost performance 1,000x and scale to over 1 billion transactions per second with in-memory storage of hundreds of TBs of data for your SQL-based applications. Christos will show how Apache Ignite handles auto-loading of SQL schema and data, SQL indexes, compound indexes support, and various forms o
Java Data as a Service High Availability
12:20pm to 1:10pm
Matterhorn 2
  • MySQL
Teng Li, Santosh praneeth Banda
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
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ò, Alkin Tezuysal
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
Zürich 2
  • OSDBMS
  • Development
Sergei Golubchik
New MariaDB major release is out of the door. It comes with new unique features, fixes old historical MariaDB/MySQL limitations, implements performance enhancements, and has better compatibility with latest MySQL versions.
MySQL Programming Fundamentals
12:20pm to 1:10pm
St. Gallen
  • MySQL
Simon Mudd
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
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
12:20pm to 1:10pm
Winterthur
  • OSDBMS
  • Development
Ilya Verbitskiy
Description: RethinkDB is an open source nosql scalable database built for real-time applications. It is a good data storage. You should give it a try if you are looking a flexible data store for rapid development or you need to scale an application with a very little effort. Abstract: Time to market has been an important challenge for all startups for years.
Programming NoSQL
1:10pm to 2:10pm
None

2:10pm to 2:35pm

2:10pm to 2:35pm
Matterhorn 1
  • OSDBMS
  • Development
Konstantin Osipov
Dynamic random access memory is getting cheaper every day, and ever growing set of applications is becoming fully RAM-resident. In this talk I'll state the case for in-memory technology in purely engineering terms: how memory-focused algorithms and data structures create a performance and efficiency edge over traditional systems, significant enough to justify an own product family:
Tools and Techniques Other
2:10pm to 2:35pm
Matterhorn 2
  • OSDBMS
  • New and Trending Topics
Shlomi Noach
....
Other Other
2:10pm to 2:35pm
Matterhorn 3
  • Scalability/Performance
  • MongoDB
Jason Terpko
This presentation will discuss scalability best practices with MongoDB. We will review how the following affect scalability: schema design, locking granularity within versions and engines, scaling vertically or horizontally, and collection sharding. Understanding how these topics can affect your application will help you avoid complications as your data and workload grows.
MongoDB Optimization Sharding
2:10pm to 2:35pm
Zürich 1
  • Development
  • MySQL
Eric Herman
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
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
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
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:10pm to 2:35pm
Winterthur
  • OSDBMS
  • Development
Laurent Doguin
In today’s world of agile business, developers and organizations benefit when JSON-based NoSQL databases and SQL-based querying come together. NoSQL provides schema flexibility, high performance, and elastic scaling. SQL provides expressive, independent data access. Developers need to deliver apps that readily evolve, perform, and scale, all to match changing business needs.
Couchbase NoSQL

2:40pm to 3:05pm

2:40pm to 3:05pm
Matterhorn 1
  • Scalability/Performance
  • MongoDB
Mark Callaghan
MyRocks and MongoRocks are RocksDB storage engines for MySQL and MongoDB. RocksDB optimizes for storage efficiency without sacrificing performance. I will use real and synthetic workloads to show how we get better compression and better SSD endurance by using MyRocks and MongoRocks. I will also explain the effort to get MyRocks deployed in production.
MySQL MongoDB Optimization
2:40pm to 3:05pm
Matterhorn 2
  • MySQL
Dimitri Vanoverbeke, Kenny Gryp
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
Matterhorn 3
  • MongoDB
Antonios Giannopoulos
With MongoDB 3.2 WiredTiger is now the default storage engine. This presentation will go through the configuration parameters when using MongoDB with WiredTiger and demonstrate performance benchmarks against different configuration values.
MongoDB
2:40pm to 3:05pm
Zürich 1
  • Scalability/Performance
  • MySQL
Seppo Jaakola
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
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
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
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
2:40pm to 3:05pm
Winterthur
  • OSDBMS
  • Architecture/Design
Alexander Krasheninnikov
Most of contemporary information systems have a stream of some events (payments, likes, votes, messages etc.). Without being able to measure this information flow, it is useless. And there is no problem, if event rate is not very high, or event stream should be measured in short-term windows, e.g. there is no need in distributed information processing.
Hadoop Spark Tools and Techniques

3:10pm to 3:35pm

3:10pm to 3:35pm
Matterhorn 1
  • OSDBMS
  • Operations and Management
Marc Berhault
This talk takes a deep dive into CockroachDB, a database whose “survive and thrive” model aims to bring the best aspects of Google's next generation database, Spanner, to the rest of the world via open source.
Data in the Cloud High Availability Replication
3:10pm to 3:35pm
Matterhorn 2
  • Scalability/Performance
  • MySQL
Krunal Bauskar
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
Matterhorn 3
  • MongoDB
Tim Vaillancourt
There is a good amount of love giving to optimizing your document design, provisioning, and even selecting your engine in MongoDB. There is little attention given to tuning Linux to handle your database efficiently.
MongoDB Devops Optimization
3:10pm to 3:35pm
Zürich 1
  • OSDBMS
  • MySQL
Abbas Ahmed
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
Zürich 2
  • OSDBMS
  • Operations and Management
Duy Hai Doan
Since the introduction of its Query Language (CQL), Cassandra is getting closer to the RDBMS world in term of features but sticking to its core distributed nature Not only does Cassandra pick the good ideas from RDBMS to adapt them to the distributed architecture but it also introduces distinct features you cannot find in the RDBMS world.
Cassandra
3:10pm to 3:35pm
St. Gallen
  • OSDBMS
Konstantin Osipov
Dynamic random access memory is getting cheaper every day, and ever growing set of applications is becoming fully RAM-resident. In this talk I'll state the case for in-memory technology in purely engineering terms: how memory-focused algorithms and data structures create a performance and efficiency edge over traditional systems, significant enough to justify an own product family:
Tools and Techniques Other
3:10pm to 3:35pm
Lausanne
  • OSDBMS
  • MySQL
Rachid Zarouali
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:10pm to 3:35pm
Winterthur
  • OSDBMS
  • New and Trending Topics
Itamar Haber
The next version of Redis will support modules. Redis Modules are pluggable libraries for extending its functionality and introducing new functionality and data types. Anyone can develop modules for themselves, or for others to use. Redis Modules are the greatest leap ever made by Redis towards unlimited versatility. The Modules API will go live soon, but you can develop new modules right now.
Redis Tools and Techniques Programming

3:40pm to 4:05pm

3:40pm to 4:05pm
Matterhorn 1
  • OSDBMS
  • Operations and Management
Peter Zaitsev
This is a high-level presentation that discusses the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this presentation, we will look at how to address such concerns to help get a migration commitment.
MySQL Other
3:40pm to 4:05pm
Matterhorn 2
  • MySQL
Dimitri Vanoverbeke, Kenny Gryp
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
Matterhorn 3
  • MongoDB
Bartłomiej Nogaś
Typically reading from secondaries can give you 100-200% improvement on your read queries, typically so we should have an honest talk about the good and the bad. The MongoDB manual will tell you to avoid reading from Secondaries.
MongoDB Optimization Tools and Techniques
3:40pm to 4:05pm
Zürich 1
  • OSDBMS
  • New and Trending Topics
Marco "The Grinch" Tusa
After some years, MySQL with Galera became the most common solution for synchronous replication. The cloud (and EC2 in particular) was one of the platforms that most successfully employed MySQL/Galera installations.
MySQL AWS 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
St. Gallen
  • Scalability/Performance
  • MongoDB
3:40pm to 4:05pm
Lausanne
  • Architecture/Design
  • MySQL
Taco Scargo, Karan Singh
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
3:40pm to 4:05pm
Winterthur
  • Scalability/Performance
  • MongoDB
Jason Terpko
This presentation will compare WiredTiger’s In-Memory Engine to Redis. We will review characteristics of each data store, how they are similar, and different. Understanding the similarities and differences will help you decide which data store is best suited for your key-value store needs.
MongoDB Redis NoSQL
4:05pm to 4:25pm
None

4:25pm to 5:15pm

4:25pm to 5:15pm
Matterhorn 1
  • Sponsored
TBD
Ignacio Iglesias
TBD
MySQL Data in the Cloud
4:25pm to 5:15pm
Matterhorn 2
  • Architecture/Design
  • MySQL
Colin Charles
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, Martin Arrieta
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
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
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
St. Gallen
  • OSDBMS
Max Liu
This session takes you to the journey of building TiDB, an open source NewSQL database inspired by Google F1 and Spanner. In the battlefield of database solutions, whenever it comes to horizontal scaling and ACID transactions, the infrastructure experts have to compromise and trade off against their own will. TiDB aims to help them kill two birds with one stone.
MySQL Data in the Cloud
4:25pm to 5:15pm
Lausanne
  • OSDBMS
  • MySQL
Ivan Zoratti
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
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 1
  • OSDBMS
  • Scalability/Performance
Johan De Gelas
Intel’s Xeon has been sitting on the mighty throne of server hardware for seven fat years now and gathered many riches from this dominant position. However, two new great houses have emerged: the house of “ARMv8 SoCs” and the house of “OpenPOWER”.
MySQL Spark
5:25pm to 6:15pm
Matterhorn 2
  • MySQL
Mark Leith
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
Matterhorn 3
  • MongoDB
Sveta Smirnova
In the WiredTiger engine many people know about its support for Btree (default) and the ability to enable LSM as well, but what few talk about is the In-Memory version of this engine. In this session, we will discuss what features do you get vs. lose when you move to in-memory. We will also discuss some use cases where it makes sense to use the in-memory options.
MongoDB Optimization Fundamentals
5:25pm to 6:15pm
Zürich 1
  • Operations and Management
  • MySQL
Miklos Szel
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
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, Kayoko GOTO, Kentoku SHIBA
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
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
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