Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

MySQL Sessions

Sponsor Percona Live Open Source Database Conference

Featured MySQL Speakers


MySQL is one of the most successful and widely-used open source database technologies ever. Learn about MySQL and its most popular variants (including Amazon RDS, MariaDB, Google CloudSQL, Percona Server and Percona XtraDB Cluster) at our MySQL track.

Percona Live provides in-depth discussions on MySQL analytics, architecture and design, security, operations, scalability and performance, and more

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

9:30am to 12:30pm

  • 9:30am to 12:30pm
    Ballroom A
    • Wildcard
    Tom De Cooman (Percona), Dimitri Vanoverbeke (Percona)
    Do you want to get more familiar on how to become a MySQL DBA? Are you a developer familiar with writing applications that use MySQL, but you feel a bit limited on how to manage a MySQL database? This full day tutorial will be mainly hands-on.
    MySQL Fundamentals
  • 9:30am to 12:30pm
    Ballroom B
    • Operations
    • Developer
    Krunal Bauskar (Percona), Matthew Boehm (Percona)
    Never used Percona XtraDB Cluster before? Are you a seasoned veteran, wanting to see the current hot stuff?Come join this full-day tutorial where we will introduce you to the concepts of a fully functional Percona XtraDB Cluster.
    MySQL Fundamentals High Availability
  • 9:30am to 12:30pm
    Ballroom C
    • Operations
    Frédéric Descamps (Oracle), Kenny Gryp (Percona), Matthew Lord (Oracle)
    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.
    MySQL High Availability
  • 9:30am to 12:30pm
    Ballroom D
    • Developer
    Colin Charles (Percona)
    The MySQL world is full of tradeoffs, and choosing a high availability (HA) solution is no exception. This session aims to look at all of the alternatives in an unbiased nature. Preference is, of course, given to open source solutions.
    MySQL High Availability Replication
  • 9:30am to 12:30pm
    Ballroom E
    • Operations
    • Developer
    Øystein Grøvlen (Oracle)
    Performance of SQL queries plays a big role in application performance. If some queries execute slowly, these queries or the database schema may need tuning. This tutorial covers query processing, optimization methods, and how the MySQL optimizer chooses a specific plan to execute SQL.
    MySQL Devops Optimization
  • 9:30am to 12:30pm
    Ballroom F
    • Operations
    • Developer
    Sveta Smirnova (Percona), Alexander Rubin (Percona)
    Performance Schema in MySQL is becoming more mature from version to version. In version 5.7, it includes extended lock instrumentation, memory usage statistics, new tables for server variables, first time ever instrumentation for user variables, prepared statements and stored routines. A lot! Amazing! And complicated! In this tutorial we will try all these new instruments out.
    MySQL Optimization Tools and Techniques
  • 9:30am to 12:30pm
    Ballroom H
    • Developer
    Giuseppe Maxia (VMware)
    MySQL 5.7 has introduced another protocol for communication with the database, which allows asynchronous operations and native document store handling. Since the changes are huge, both developers and DBAs are uncertain about what can be done and how.
    MySQL Programming NoSQL
  • 9:30am to 12:30pm
    Room 203
    • Operations
    Yoshinori Matsunobu (Facebook)
    This is a tutorial about MyRocks: RocksDB Storage Engine for MySQL (https://github.com/facebook/mysql-5.6). MyRocks is a project to utilize space and write optimized LSM database with MySQL.
    RocksDB MySQL

1:30pm to 4:30pm

  • 1:30pm to 4:30pm
    Ballroom A
    • Wildcard
    Tom De Cooman (Percona), Dimitri Vanoverbeke (Percona)
    Do you want to get more familiar on how to become a MySQL DBA? Are you a developer familiar with writing applications that use MySQL, but you feel a bit limited on how to manage a MySQL database? This full day tutorial will be mainly hands-on.
    MySQL Fundamentals
  • 1:30pm to 4:30pm
    Ballroom B
    • Operations
    • Developer
    Krunal Bauskar (Percona), Matthew Boehm (Percona)
    Never used Percona XtraDB Cluster before? Are you a seasoned veteran, wanting to see the current hot stuff?Come join this full-day tutorial where we will introduce you to the concepts of a fully functional Percona XtraDB Cluster.
    MySQL Fundamentals High Availability
  • 1:30pm to 4:30pm
    Ballroom C
    • Operations
    Frédéric Descamps (Oracle), Kenny Gryp (Percona), Matthew Lord (Oracle)
    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.
    MySQL High Availability
  • 1:30pm to 4:30pm
    Ballroom D
    • Operations
    David Turner (Uber), René Cannaò (Dropbox / ProxySQL), Derek Downey (Pythian)
    Overview: There is a stigma attached to database proxies when it comes to MySQL. This tutorial hopes to blow away that stigma by showing you what can be done with a proxy designed from the ground up to be performant. That proxy is ProxySQL.
    MySQL High Availability Sharding
  • 1:30pm to 4:30pm
    Ballroom E
    • Developer
    Morgan Tocker (Oracle)
    Many users who follow MySQL development are aware that recent versions introduce a number of improvements to query execution (via the addition of new execution strategies, and an improved cost model). But what is not talked about enough, is that the diagnostic features are also significantly better.
    MySQL Optimization Fundamentals
  • 1:30pm to 4:30pm
    Ballroom F
    • Business / Case Studies
    • Developer
    Peter Zaitsev (Percona)
    InnoDB is the most commonly used storage engine for MySQL and Percona Server and is the focus for the majority of storage engine development by the MySQL and Percona Server teams. In this tutorial, we will look at the InnoDB architecture, including new developments in MySQL 5.6 as well as Percona Server.
    MySQL Other OSDB Optimization
  • 1:30pm to 4:30pm
    Ballroom H
    • Operations
    Michael Coburn (Percona), Roma Novikov (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.
    MySQL Monitoring
  • 9:00am to 9:15am
    None
    • Business / Case Studies
    Peter Zaitsev (Percona)
    Peter Zaitsev welcomes everyone to Percona Live Open Source Database Conference 2017
    MySQL Fundamentals Business Intelligence

11:30am to 12:20pm

  • 11:30am to 12:20pm
    Ballroom A
    • Operations
    • Developer
    Sveta Smirnova (Percona)
    Performance Schema in version 5.6, released in February, 2013, is really powerful tool which can help DBA to find why every trickiest issue started to occur. Version 5.7 introduces even more instruments and tables. And while all these give you great power, you can stuck choosing which instrument to use.
    MySQL Optimization Tools and Techniques
  • 11:30am to 12:20pm
    Ballroom C
    • Developer
    Geir Høydalsvik (Oracle)
    In this session, I will describe the new features that have all ready been announced for MySQL 8.0. In addition to Data Dictionnary, CTEs and windows function the session is covering: * Move to utf8(mb4) as MySQL's default character set * Language specific case insensitive collation for 21 languages (utf8) * Invisible index * Descending indexes * Improve usability of UUID and IPV6
    MySQL Fundamentals
  • 11:30am to 12:20pm
    Ballroom D
    • Operations
    • Business / Case Studies
    Marco "The Grinch" Tusa (Percona)
    ProxySQL is a flexible, fast and highly configurable piece of software that provides dramatic improvement to your cluster and high availability (HA) architecture. The presentation will discuss how to deploy ProxySQL in support of architectures using standard master/slave, Percona XtraDB Cluster/MySQL-Galera or MHA solutions. The presentation discusses details on: - ProxySQL host group -
    MySQL High Availability Sharding
  • 11:30am to 12:20pm
    Ballroom E
    • Developer
    Peter Zaitsev (Percona)
    In this talk, I will introduce Percona’s latest open source software tool: Percona Monitoring and Management (PMM). I will briefly discuss high-level aspects of monitoring we’ve found work well in practice at Percona, and then spend the rest of the time with an online demonstration of how to use this tool to identify common MySQL issues.
    MySQL Monitoring
  • 11:30am to 12:20pm
    Ballroom F
    • Operations
    Andrew Regner (Facebook)
    MySQL is by far the most common choice among Facebook engineering teams when they are looking for a persistent data store for their product or application. Not all of this data goes into the "Facebook Graph" as not everything developed inside Facebook applies to a user or something they are sharing.
    MySQL Tools and Techniques Sharding
  • 11:30am to 12:20pm
    Ballroom H
    • Operations
    Ben Mildren (DigitalOcean)
    Percona Monitoring and Management (PMM) is a wonderful solution, it aims to provide out of the box monitoring and management for your MySQL (and/or MongoDB) environment.
    MySQL Devops Monitoring
  • 11:30am to 12:20pm
    Room 210
    • Developer
    Preetam Jinka (VividCortex)
    I’ve been learning about database internals by learning the theory, seeing how other systems have implemented ideas, and trying to implement them myself. Of course, it’s not always easy, and I’m not making anything that compares to the scale of something like MySQL or MongoDB, but reinventing a few small wheels here and there has given me a better understanding of how bigger systems work.
    MySQL
  • 11:55am to 12:20pm
    Room 209
    • Operations
    Matthew Boehm (Percona)
    Proper indexing is key to database performance. Find out how MySQL uses indexes for query execution, then come up with an optimal index strategy. In this session you’ll also learn how to know when you need an index, and to also get rid of indexes that you don’t need to speed up queries.
    MySQL

1:20pm to 2:10pm

  • 1:20pm to 2:10pm
    Ballroom A
    • Developer
    Øystein Grøvlen (Oracle)
    Two new SQL features in MySQL 8.0 are presented in this session; Common Table Expressions (CTE) and Window Functions.In their simplest form, CTEs are a way of creating a view/temporary table for usage in a single query. However, they have many more use cases. In particular, when using the RECURSIVE form of CTEs, it is possible to perform advanced tasks with few lines of code.
    MySQL Optimization Programming
  • 1:20pm to 2:10pm
    Ballroom B
    • Business / Case Studies
    Andrea Ponzo (Lastminute.com), Rick Pizzi (Lastminute.com)
    Even if InnoDB is universally recognized by DBAs as "the" engine to use for production data, there are use cases where InnoDB just does not fit. In this talk we will introduce the most popular engines available for MySQL to date, focusing on the limitations that plague InnoDB when it's about inserting rows at high rate and/or using a random primary key, like an UUID.
    MySQL Optimization Tools and Techniques
  • 1:20pm to 2:10pm
    Ballroom C
    • Operations
    • Developer
    Manyi Lu (Oracle)
    There are substantial improvements in the Optimizer in MySQL 8.0. Most noticeably, we have added support for advanced SQL features like common table expressions, windowing functions and grouping() function. We also made DBAs’ life easier with invisible index, and additional hints that can be used together with the query rewrite plugin.
    MySQL Optimization NoSQL
  • 1:20pm to 2:10pm
    Ballroom D
    • Operations
    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 session walks through orchestrator setup, deployment and usage best practices.
    MySQL Tools and Techniques High Availability
  • 1:20pm to 2:10pm
    Ballroom E
    • Operations
    • Developer
    Colin Charles (Percona), Ronald Bradford (Pythian), Hank Eskin (WheresGeorge.com & EV-CPO.com)
    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
    MariaDB MySQL Tools and Techniques
  • 1:20pm to 2:10pm
    Ballroom F
    • Developer
    zhai weixiang (Alibaba)
    The original MySQL provides an ability that if innodb_read_only is turned on, you can setup multiple instances based on same data file.
    MySQL Optimization Replication
  • 1:20pm to 2:10pm
    Room 210
    • Operations
    Matt Ullmer (Yelp)
    Yelp has grown rapidly over the last several years, and we were forced to quickly scale our infrastructure to keep up.
    MySQL Optimization Tools and Techniques
  • 1:20pm to 1:45pm
    Room 209
    • Operations
    Michael Coburn (Percona), Roma Novikov (Percona)
    Troubleshooting performance issues can be a bit tricky, especially when you’re given a broad statement that the database is slow. Learn to direct your attention to the correct moving pieces and fix what needs your attention. Learn how all this is done at Percona, what we monitor and track, and the tools we use.
    MySQL Tools and Techniques Monitoring
  • 1:50pm to 2:15pm
    Room 209
    • Operations
    Marcos Albe (Percona)
    The MySQL world is full of tradeoffs and choosing a High Availability (HA) solution is no exception. Learn to think about High Availability the Percona way, and use the solutions that we deploy on a regular basis.
    MySQL

2:20pm to 3:10pm

  • 2:20pm to 3:10pm
    Ballroom B
    • Operations
    • Business / Case Studies
    David Peterson (Salesforce)
    We’ve all used or heard about various filesystems like ext3, ext4, or XFS but what about copy-on-write filesystems like btrfs or ZFS. With XFS being the de facto standard to host MySQL on, learn why Pardot chose ZoL (ZFS On Linux) instead to host their highly transactional MySQL database servers in production on. ZoL is a port of OpenZFS to Linux that was released in 2013.
    MySQL Optimization Tools and Techniques
  • 2:20pm to 3:10pm
    Ballroom C
    • Operations
    • Developer
    Sunny Bains (Oracle)
    The next version of MySQL will be a major release of new features and capabilities including a new data dictionary hosted in InnoDB. Learn all about the changes coming in the next version of InnoDB.
    MySQL Fundamentals
  • 2:20pm to 3:10pm
    Ballroom D
    • Operations
    Jonah Berquist (GitHub)
    gh-ost is a new tool by GitHub which changes the paradigm of MySQL online schema changes, designed to overcome today's limitations and difficulties in online migrations.
    MySQL Devops Tools and Techniques
  • 2:20pm to 3:10pm
    Ballroom E
    • Operations
    Brian Cain (Dropbox)
    Overview: There are a number of built-in MySQL commands and third party tools out there for generating data to help tune and diagnose your servers. All that information is great, but not always easy to parse through; especially if you are in the middle of an emergency.
    MySQL Devops Tools and Techniques
  • 2:20pm to 3:10pm
    Ballroom F
    • Operations
    • Developer
    Lixun Peng (Alibaba Cloud)
    Flashback: - Makes use of the binary log to roll back an instance, database or table to a previous snapshot. - Is available as a first release is MariaDB 10.2.4/RDS MySQL 5.6. - Is implemented on the server-level, so supports all storage engines. - Makes use of full image format binary logs. - Is currently a mysqlbinlog feature (the --flashback option) The talk will discuss how Flashback
    MariaDB MySQL Devops
  • 2:20pm to 2:45pm
    Room 209
    • Operations
    Daniel Kowalewski (Percona)
    MySQL is famous for something you can install in less than five minutes and get going in terms of development. But you want to run this in production, at scale, so why not learn the best practices around installation, configuration, deployment, and backups.
    MySQL
  • 2:50pm to 3:15pm
    Room 209
    • Operations
    Jervin Real (Percona)
    MySQL 5.7 has a lot of new features, and if you've dabbled with something older in the past, it is definitely worth learning what's new and how to use the new features that come with it. Learn about some features such as multi-source replication, global transaction IDs (GTIDs), security improvements, etc.
    MySQL

3:50pm to 4:40pm

  • 3:50pm to 4:40pm
    Ballroom A
    • Developer
    Bill Karwin (SchoolMessenger)
    We all have tasks from time to time for bulk-loading external data into MySQL. What's the best way of doing this? That's the task I faced recently when I was asked to help benchmark a multi-terabyte database. We had to find the most efficient method to reload test data repeatedly without taking days to do it each time.
    MySQL
  • 3:50pm to 4:40pm
    Ballroom B
    • Operations
    Daniël van Eeden (Booking.com)
    If your MySQL connections travel trough your network and maybe even over the internet then there are many possibilities where someone could eavesdrop. Protecting this with SSL (or TLS actually) is the obvious solution, but there are many SSL related settings. And you need a certificate, which you could buy or generate one yourself.
    MySQL
  • 3:50pm to 4:40pm
    Ballroom C
    • Developer
    Luis Soares (Oracle), Lars Thalmann (Oracle)
    The most popular High Availability (HA) techniques deployed are based on making services redundant, in particular by means of replication. This fits quite naturally in the MySQL universe as the MySQL server has provided a mature replication solution for over a decade now.
    MySQL High Availability Replication
  • 3:50pm to 4:40pm
    Ballroom D
    • Operations
    Susanne Lehmann (Yelp)
    How do you correctly direct traffic to your databases? How do you add new replicas or remove broken or retired replicas from the traffic flow? How do you scale elastically? Every company has their own way of how they solve the service discovery problem. Some use solely DNS, others use VIPs, Consul, …..etc.
    MySQL Tools and Techniques High Availability
  • 3:50pm to 4:40pm
    Ballroom F
    • Operations
    Garrett Plasky (Evernote), Chris Shumake (Evernote, Inc. )
    We'll be discussing using Google Cloud Platform and how it's different from a locally-controlled co-lo.
    MySQL Devops Data in the Cloud
  • 3:50pm to 4:40pm
    Room 210
    • Developer
    MC Brown (Continuent)
    In this session we'll look at Tungsten Replicator, which enables real-time and efficient replication of data from your transactional database. We'll focus on the filtering side, for massaging your data before/during replication.
    MySQL Fundamentals
  • 3:50pm to 4:15pm
    Room 209
    • Operations
    Laurynas Biveinis (Percona)
    Percona Server 5.7 takes MySQL 5.7 as a base and adds new and interesting features like column encryption, an audit plugin, a high performance threadpool, and many other "enterprise" features made open. Learn about all these features that will help your queries run faster, more consistently, achieve higher uptimes, and take the guesswork out of management!
    MySQL
  • 4:20pm to 4:45pm
    Room 209
    • Operations
    Ramesh Sivaraman (Percona), Krunal Bauskar (Percona)
    When it comes to High Availability, Percona has spent time developing the Percona XtraDB Cluster product, based on Galera Cluster, and integrating it with ProxySQL to have a great out-of-the-box synchronous replication setup. Learn when its right to use this solution, and which deployments you would consider it for.
    MySQL

4:50pm to 5:15pm

  • 4:50pm to 5:15pm
    Ballroom A
    • Business / Case Studies
    • Developer
    Marco "The Grinch" 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 lacks in sharding capability.
    MySQL Tools and Techniques Sharding
  • 4:50pm to 5:15pm
    Ballroom B
    • Developer
    Mark Callaghan (Facebook)
    MyRocks is the RocksDB storage engine for MySQL. We have continued to make it better in the last 6 months. I will explain the new features and improvements to performance and efficiency. I will also explain the workloads for which it might be a great fit. Finally I will describe the differences between InnoDB and MyRocks.
    RocksDB MySQL Optimization
  • 4:50pm to 5:15pm
    Ballroom C
    • Operations
    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.
    MySQL Fundamentals
  • 4:50pm to 5:15pm
    Room 209
    • Operations
    Sveta Smirnova (Percona)
    The MySQL storage engine landscape is wide and varied (and for a very long time, it was the only database server to support this concept) - it started with MyISAM, and it became a solid database with the popular and default InnoDB storage engine.
    MySQL
  • 4:50pm to 5:15pm
    Room 210
    • Business / Case Studies
    Denis Magda (GridGain)
    Learn how to boost performance 1,000x with in-memory store of petabytes of data for your MySQL-based applications. Apache Ignite is an in-memory computing platform that is built on top of a distributed key-value store and provides full-fledged SQL support.
    MySQL PostgreSQL Optimization

5:15pm to 5:40pm

  • 5:15pm to 5:40pm
    Ballroom A
    • Business / Case Studies
    • Wildcard
    Martin Arrieta (Pythian), Amanda MacDonald (Pythian)
    Clients are implementing changes at a fast rate, putting extra demand on us, the humans behind the task. How do we reduce human errors, while keeping up with the demand and still provide value? Would you get into a plane if the pilot didn’t check the aircraft? Ever had surgery? How do you know the surgeon didn’t leave a sponge behind?
    MySQL MongoDB Tools and Techniques
  • 5:15pm to 5:40pm
    Ballroom B
    • Business / Case Studies
    • Developer
    Herman Lee (Facebook Inc.)
    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.
    RocksDB MySQL Devops
  • 5:15pm to 5:40pm
    Ballroom C
    • Developer
    Georgi Kodinov (Oracle), Mike Frank (Oracle)
    This session provides the developer centric view on MySQL 8.0 security. MySQL 8.0 is continuing in the direction set by MySQL 5.7: to be secure by default.
    MySQL Programming
  • 5:15pm to 5:40pm
    Ballroom E
    • Business / Case Studies
    • Developer
    Baron Schwartz (VividCortex)
    In this talk you'll learn how we store and analyze time series data efficiently at VividCortex, using MySQL and Redis as a storage engine. VividCortex's time series workload presents interesting and unusual challenges that most conventional time series databases don't handle well, at a speed and volume that is also unusual.
    MySQL Time Series Metrics
  • 5:15pm to 5:40pm
    Room 210
    • Business / Case Studies
    Simon Mudd (booking.com)
    You’ve deployed automation, enabled automatic master failover and tested it many times: great, you can now sleep at night without being paged by a failing server. However, when you wake up in the morning, things might not have gone the way you expect. This talk will be about such surprise. Once upon a time, a failure brought down a master. Automation kicked in and fixed things.
    MySQL Devops High Availability
  • 5:20pm to 5:45pm
    Room 209
    • Operations
    Dimitri Vanoverbeke (Percona)
    MySQL and MariaDB Server are providing many new features that can help with security and encryption, things that are becoming extremely important in today's world. Learn how to benefit from the usage of roles, to at-rest-encryption. At the end of this, you should have a securely configured MySQL instance!
    MySQL

6:00pm to 7:00pm

  • 6:00pm to 7:00pm
    None
    • Business / Case Studies
    Mariella Di Giacomo (ViaSat), Manjot Singh (Percona)
    Mariella Di Giacomo - Successful stories around MySQL and MariaDB Multi-Source Replication Manjot Singh - What is Sharding
    MySQL
  • 6:00pm to 7:00pm
    None
    • Business / Case Studies
    Yoshinori Matsunobu (Facebook), Frédéric Descamps (Oracle), Sveta Smirnova (Percona), Shlomi Noach (GitHub), René Cannaò (Dropbox / ProxySQL)
    1) "MyRocks Features and Roadmaps” - Yoshinori Matsunobu ····································································································································· 2) "Meet the MySQL Engineering Team" - Frederic Descamps Abstract: MySQL Engineering team leaders are in town, please come to meet them and give feedback on current MySQL products.
    MariaDB RocksDB MySQL
  • 9:25am to 9:45am
    None
    • Business / Case Studies
    Richard Hipp (SQLite.org), Baron Schwartz (VividCortex), MC Brown (Continuent), Peter Zaitsev (Percona)
    Join Percona and the Diamond sponsors of the conference, VividCortex & Continuent to talk database trends
    MySQL MongoDB Web Services
  • 9:50am to 10:10am
    None
    • Business / Case Studies
    Tomas Ulin (Oracle)
    Join Tomas Ulin, VP of MySQL Engineering at Oracle, to get the big picture overview of MySQL 8.0 development priorities, features that have already been delivered, and what is coming in upcoming releases.
    MySQL Business Intelligence

11:10am to 12:00pm

  • 11:10am to 12:00pm
    Ballroom A
    • Operations
    Giuseppe Maxia (VMware)
    Replication in the last years has been a game of marketing and bragging, where features have been presented as life-changing and highly innovative. Sometimes, these features are really good, and meet the users expectations.
    MySQL Replication
  • 11:10am to 12:00pm
    Ballroom B
    • Developer
    Rick James ((self))
    Indexing is a black art? Not really. But there are a lot of subtle issues and interactions to learn. This tutorial presents virtually everything there is to know about indexes. It takes the "cookbook" approach of saying "this SELECT begs for this INDEX", then deep dives into "why". This lecture moderately fast-paced.
    MySQL Optimization
  • 11:10am to 12:00pm
    Ballroom C
    • Operations
    • Developer
    Krunal Bauskar (Percona)
    Percona XtraDB Cluster 5.7 is our latest offering in the clustering space.
    MySQL High Availability Replication
  • 11:10am to 12:00pm
    Ballroom D
    • Operations
    Krzysztof Książek (Severalnines AB)
    Load balancing MySQL connections and queries using HAProxy has been popular in the past years. Recently however, we have seen the arrival of MaxScale, MySQL Router, ProxySQL and now also Nginx as a reverse proxy.
    MySQL Tools and Techniques High Availability
  • 11:10am to 12:00pm
    Ballroom E
    • Developer
    Colin Charles (Percona)
    The new MariaDB Server 10.2 release is out. It has some interesting new features, but beyond just a feature overview we need to look at how to use some of them. Learn about window functions, common table expressions, finer grained CREATE USER statements, and a lot more -- including getting mysqlbinlog up to parity with MySQL.
    MariaDB MySQL Tools and Techniques
  • 11:10am to 12:00pm
    Ballroom H
    • Developer
    • Wildcard
    Michael Benshoof (Percona), Alexander Rubin (Percona)
    The goal of the talk is to review the GIS improvements in MySQL 5.7 and new additions in MySQL 8.0 (new this year!), provide some general review of the functionality, as well as some working demos.
    MySQL MongoDB
  • 11:10am to 12:00pm
    Room 210
    • Operations
    • Business / Case Studies
    Alkin Tezuysal (Percona), René Cannaò (Dropbox / ProxySQL)
    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

1:00pm to 1:50pm

  • 1:00pm to 1:50pm
    Ballroom A
    • Operations
    • Developer
    Evan Elias (Tumblr)
    Skeema (http://skeema.net) is a new open source CLI tool for managing MySQL schemas and migrations. It allows you to easily track your schemas in a repo, supporting a pull-request-based workflow for schema change submission, review, and execution. This session will introduce Skeema, walking through its functionality and usage.
    MySQL Devops Tools and Techniques
  • 1:00pm to 1:50pm
    Ballroom B
    • Operations
    Kenny Gryp (Percona), Tom De Cooman (Percona)
    Upgrading MySQL databases do not come without risk. There is no guarantee that no problems will happen if you move to a new major MySQL version. Should we just upgrade and rollback immediately if problems occur?
    MySQL Tools and Techniques Fundamentals
  • 1:00pm to 1:50pm
    Ballroom C
    • Operations
    Seppo Jaakola (Codership)
    Data inconsistency is the worst problem that can happen for synchronous database cluster. After data inconsistency has sneaked in the cluster, it will sooner or later appear during replication processing, simply because applying of replication events is not possible in some cluster node, due to missing rows, excessive rows or wrong values in the row columns.
    MySQL High Availability Replication
  • 1:00pm to 1:50pm
    Ballroom D
    • Operations
    • Business / Case Studies
    Sugu Sougoumarane (YouTube), Robert Navarro (StitchLabs, Inc.)
    We'll start off with an overview of Vitess and will drill down on its newer features: MySQL protocol, bulk statements, 2PC and Messaging. Following this, Robert Navarro from Stitch Labs will talk about their production experience with Vitess & Percona, how they migrated, what they like and what they'd like to see going forward.
    MySQL Data in the Cloud Sharding
  • 1:00pm to 1:50pm
    Ballroom E
    • Business / Case Studies
    Jean-François Gagné (Booking.com)
    In the last 24 months, MySQL/MariaDB replication speed has improved a lot, thanks to parallel replication. MySQL and MariaDB Server have different types of parallel replication; in this talk, I present the different implementations which will allow us to understand their limitations and tuning parameters.
    MariaDB MySQL Tools and Techniques
  • 1:00pm to 1:50pm
    Ballroom G
    • Operations
    • Wildcard
    Patrick King (Yelp)
    Abstract: Come on a journey with Patrick as he walks you through his transformation from a PostgreSQL DBA to a MySQL DBA. This talk will be a story of Patrick's journey where we'll walk through some of the major differences between PostgreSQL and MySQL and how we use both of them at Yelp.
    MySQL Devops Tools and Techniques

2:00pm to 2:50pm

  • 2:00pm to 2:50pm
    Ballroom A
    • Operations
    Mark Filipi (SurveyMonkey), Brian Cain (Dropbox)
    Overview: Many MySQL shops have made the transition from MySQL 5.5 to 5.6 in the last few years, but GTID (global transaction identifier) implementation has often been considered too difficult or risky a change. MySQL 5.7 is making GTID implementation easier, but it may not yet be clear why to convert.
    MySQL Replication
  • 2:00pm to 2:50pm
    Ballroom B
    • Business / Case Studies
    Maxim Bublis (Dropbox), Peter Boros (Dropbox)
    At Dropbox, with 1000s of machines running MySQL, performance is important.
    MySQL Optimization
  • 2:00pm to 2:50pm
    Ballroom C
    • Developer
    dengcheng he (Alibaba), jiayi wang (Alibaba)
    MyRocks is a popular open source storage engine for MySQL, built on top of RocksDB storage library. For the past few years, Facebook spent plenty of time on it, to make it better and well-known, and claimed that MyRocks provides much better compression ratio and much smaller write amplification. rumor or truth?
    RocksDB MySQL Fundamentals
  • 2:00pm to 2:50pm
    Ballroom D
    • Operations
    Matthias Crauwels (Ghent University)
    Currently we are starting to roll 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.
    MySQL Devops Data as a Service
  • 2:00pm to 2:50pm
    Ballroom E
    • Developer
    Vicentiu-Marian Ciorbaru (MariaDB Foundation)
    MariaDB Server 10.2 has brought two new important querying features, Common Table Expressions (CTEs) and Window Functions.
    MariaDB MySQL Optimization
  • 2:00pm to 2:50pm
    Room 210
    • Developer
    Preetam Jinka (VividCortex)
    VividCortex monitors lots of production database servers, which means we get to see lots of different database problems. One specific type of problem that we like to focus on is database stalls. We define stalls as short periods of time, typically one second, when work isn’t getting done.
    MySQL

3:30pm to 4:20pm

  • 3:30pm to 4:20pm
    Ballroom B
    • Operations
    Andrew Moore (Percona), Jervin Real (Percona)
    Backups are crucial in a world where data is digital and uptime is revenue. Environments are no longer bound to traditional data centers, and span multiple cloud providers as well a plethora of heterogeneous environments. We need bulletproof backups and impeccable recovery processes.
    MySQL Tools and Techniques High Availability
  • 3:30pm to 4:20pm
    Ballroom C
    • Operations
    • Developer
    Yves Trudeau (Percona)
    Databases have always been heavy users for filesystems. They have strict durability requirements, they submit a high number of concurrent IO requests which are then required to complete in a timely manner. No wonder the choice of a filesystem has always been critical and workload dependent.
    MySQL Programming Data in the Cloud
  • 3:30pm to 4:20pm
    Ballroom D
    • Operations
    • Business / Case Studies
    Carmen Mason (VitalSource Technologies), Allan Mason (Advance Auto Parts, Inc)
    There are challenges in taking an existing infrastructure from a data center to Google Cloud. It is an understatement to say that there are plenty of differences between the two. For our in-house setup, VitalSource uses MHA with MHA-Helper managing the VIP for us. In GCE, we needed to separate the access management from the topology manager.
    MySQL Data in the Cloud High Availability
  • 3:30pm to 4:20pm
    Ballroom E
    • Developer
    Sergei Petrunia (MariaDB Corporation)
    MariaDB Server has had histograms since MariaDB 10.0, now, MySQL 8.0 will have them too.
    MariaDB MySQL Other OSDB
  • 3:30pm to 4:20pm
    Room 210
    • Operations
    Johan Andersson (Severalnines)
    MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, designed to deliver 99.999% availability. It provides shared-nothing clustering and auto-sharding for MySQL, accessed via SQL and NoSQL interfaces. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability.
    MySQL High Availability Sharding

4:30pm to 4:55pm

  • 4:30pm to 4:55pm
    Ballroom A
    • Operations
    • Business / Case Studies
    Nathan Northcutt (GoDaddy)
    For the last 2 decades, GoDaddy has expanded its core business from a simple DNS provider to a fully-fledged cloud hosting company for small businesses around the globe. Our customers daily experience is directly dependent on the millions of MySQL databases managed by our devops team.
    MySQL Devops Data as a Service
  • 4:30pm to 4:55pm
    Ballroom C
    • Developer
    Ming Chen (Tencent)
    Support for both high-availability and strong-consistency is a great challenge for MySQL cluster. Built on Paxos and with minimal modification to MySQL, PhxSQL provides full functionalities completely compatible with MySQL, zookeeper-level consistency, and semi-sync like performance when more than half of cluster nodes work.
    MySQL High Availability Replication
  • 4:30pm to 4:55pm
    Ballroom E
    • Developer
    Kayoko GOTO (Spider Mroonga Storage Engine ), Kentoku SHIBA (Spiral Arms., Ltd)
    When your database is growing, you definitely need to think about other techniques like database sharding. SPIDER is a MariaDB Server / MySQL storage engine for database sharding. Using SPIDER, you can access your data efficiently across multiple database backends. In this time we will introduce the following things. 1. why SPIDER? what SPIDER can do for you? 2. when SPIDER is right for you?
    MySQL Tools and Techniques Sharding
  • 4:30pm to 4:55pm
    Ballroom F
    • Operations
    Brian Welcker (Amazon RDS)
    Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you to focus on your applications and business. This talk will provide guidance and tips for optimizing MySQL-compatible workloads on RDS.
    MySQL Optimization
  • 4:30pm to 4:55pm
    Ballroom H
    • Operations
    • Business / Case Studies
    Jonathan Wage (Opensky), Rick Vasquez (Percona)
    As a TAM at Percona I have seen multiple environments with managed services of just MySQL, just MongoDB and with hybrid deployments of MongoDB and MySQL. I'd like to familiarize potential users of both open source databases to the best practices of having a hybrid environment.
    MySQL MongoDB Optimization

5:00pm to 5:25pm

  • 5:00pm to 5:25pm
    Ballroom A
    • Wildcard
    Alexey Kopytov (.)
    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.
    MySQL Optimization Tools and Techniques
  • 5:00pm to 5:25pm
    Ballroom C
    • Operations
    Valerie Parham-Thompson (Pythian), Ivan Groenewold (Pythian)
    In this session we will share our experiences using gh-ost for long-running schema changes in a multi-tier replication topology under high-volume traffic. This will include sharing how gh-ost can work with topologies using the Tungsten Replicator. We’ll share the ideal combination of commands to use in this setup, and discuss reasons we chose gh-ost over our old friend pt-online-schema-change.
    MySQL Tools and Techniques
  • 5:00pm to 5:25pm
    Ballroom E
    • Developer
    Sang-Won Lee (Sungkyunkwan University)
    We are witnessing the advent of all-flash era. As pure read/write block device, flash SSD simply outperforms harddisk in terms of IOPS and cost-effectiveness. But this is not the whole story. As IO device, flash SSD has many different characteristics: to name a few, asymmetric read/write performance, abundant internal parallelism and an indirect address mapping layer, called FTL.
    MySQL Other OSDB
  • 5:00pm to 5:25pm
    Room 210
    • Business / Case Studies
    • Developer
    Alexander Yakovlev (Wamba)
    In my talk I will share with you our solution to the performance problem of MySQL. We were using MySQL and HandlerSocket over 5 years and at some point we decided to migrate from 5.6 to 5.7. The problem was that there was no HandlerSocket in 5.7.
    MySQL NoSQL
  • 9:10am to 9:25am
    None
    • Business / Case Studies
    Peter Zaitsev (Percona)
    Join Peter Zaitsev, CEO of Percona, as he discusses the growth and adoption of open source databases and Percona’s commitment to remaining an unbiased champion of the open source database ecosystem. He will also provide updates and highlight exciting new developments in Percona Server software for MySQL and MongoDB.
    MySQL MongoDB
  • 9:25am to 9:50am
    None
    • Wildcard
    Jean-François Gagné (Booking.com)
    Join Jean-François Gagné as he presents a metric for observing Booking.com’s system health. This metric is not technical (not MySQL or Linux related) but it is one of the most important metric Booking.com has to detect a problem on the website. Many things impact this metric, including the time of the day, the day of the week or the season of the year.
    MariaDB MySQL Devops

11:00am to 11:50am

  • 11:00am to 11:50am
    Ballroom A
    • Developer
    wei hu (Alibaba), dengcheng he (Alibaba)
    Last year, we joined percona live the very first time and bring the world AliSQL, a MySQL branch maintained by Alibaba Database Team. We share many improvements we made on AliSQL, including Column Compression, Double Read Buffer, "Hot SKU", SQL Firewall, and so on. Some of these improvements have been absorbed by the Mainstream.
    MySQL Optimization High Availability
  • 11:00am to 11:50am
    Ballroom B
    • Operations
    Stacy Yuan (Yahoo), Kushal Shah (Yahoo), Yngve Eriksson (Yahoo)
    In this case study, we will present Yahoo's backup and recovery strategy. We will present How to optimize backups of large amounts data using full, incremental, compress, parallel options. How to get the consistent backup using slave-info, safe-slave-backup, no-lock How to automate slave rebuild using Xtrabackup How to perform point-in-time-recovery How to monitor and validate the backu
    MySQL Devops High Availability
  • 11:00am to 11:50am
    Ballroom C
    • Developer
    Ståle Deraas (Oracle)
    A new data dictionary based on transactional tables is being developed for MySQL Server. People could already play with it in the 8.0.0 dmr. This project is a huge step forward, improving many aspects of the server even Information_Schema! The transactional data dictionary provides a new way of accessing metadata for use both by server and plug-in developers.
    MySQL Optimization
  • 11:00am to 11:50am
    Ballroom D
    • Operations
    • Business / Case Studies
    Stephane Combaudon (Slice Technologies)
    Automating deployments is a key success factor in the cloud. It is actually a great way to leverage the flexibility of the cloud.
    MySQL Devops Data in the Cloud
  • 11:00am to 11:50am
    Ballroom E
    • Operations
    • Developer
    Sergei Petrunia (MariaDB Corporation)
    MyRocks is a new storage engine based on RocksDB. It is included in MariaDB Server, and together the combination is called MariaRocks.
    MariaDB RocksDB MySQL
  • 11:00am to 11:50am
    Ballroom F
    • Operations
    • Developer
    René Cannaò (Dropbox / ProxySQL), Frédéric Descamps (Oracle)
    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.
    MySQL Tools and Techniques Programming
  • 11:00am to 11:50am
    Room 210
    • Business / Case Studies
    Jean-François Gagné (Booking.com)
    Since 5.7.2, MySQL implements parallel replication in the same schema, also known as LOGICAL_CLOCK (DATABASE based parallel replication is also implemented in 5.6 but this is not covered in this talk). In early 5.7 versions, parallel replication was based on group commit (like MariaDB) and 5.7.6 changed that to intervals. Intervals are more complicated but they are also more powerful.
    MySQL Tools and Techniques Replication

12:50pm to 1:40pm

  • 12:50pm to 1:40pm
    Ballroom A
    • Developer
    Laurynas Biveinis (Percona)
    We will discuss selected areas of Percona Server for MySQL 5.7 internals that are mostly related to InnoDB buffer pool management and flushing, from a performance and scalability point of view.
    MySQL Programming
  • 12:50pm to 1:40pm
    Ballroom B
    • Operations
    Károly Nagy (Dropbox), Peter Boros (Dropbox)
    Automation is a critical part in every infrastructure if you want to keep your sanity. We will show you with practical examples how you can move on from your shell scripts and ansible playbooks to build a self-managing infrastructure which works on thousands, tens of thousands or even more servers without too much human interaction.
    MySQL Devops Tools and Techniques
  • 12:50pm to 1:40pm
    Ballroom C
    • Developer
    Bill Karwin (SchoolMessenger)
    MySQL 8 introduces support for ANSI SQL recursive queries with common table expressions, a powerful method for working with recursive data references. Until now, MySQL application developers have had to use workarounds for hierarchical data relationships. It's time to write SQL queries in a more standardized way, and be compatible with other brands of SQL implementations.
    MySQL Optimization
  • 12:50pm to 1:40pm
    Ballroom D
    • Operations
    Tom Krouper (GitHub)
    GitHub has been using gh-ost for online schema migrations since before it was open sourced in August of 2016. Once gh-ost was in place helping our migrations run more smoothly, the Database Engineers didn't want to have to be involved in running them anymore. In this session we'll discuss the steps we took to remove humans from most of the steps of running a migration.
    MySQL Tools and Techniques
  • 12:50pm to 1:40pm
    Ballroom E
    • Business / Case Studies
    Eric Herman (Booking.com)
    MySQL/MariaDB replication is asynchronous. You can make replication faster by using better hardware (faster CPU, more RAM, or quicker disks), or you can use parallel replication to remove it single-threaded limitation; but lag can still happen.
    MariaDB MySQL Tools and Techniques
  • 12:50pm to 1:40pm
    Ballroom F
    • Operations
    • Developer
    Tim Sharp (Percona)
    This will be a survey of Percona Server's diagnostic features that make it unique from standard MySQL. Topics will include the various performance counters for providing a better understanding of your database metrics as well a review of the INFORMATION_SCHEMA Tables and enhancements to SHOW ENGINE INNODB STATUS. Percona: we don't just make MySQL, we make MySQL better.
    MySQL Tools and Techniques Metrics
  • 12:50pm to 1:40pm
    Ballroom G
    • Operations
    • Developer
    Ilya Kosmodemiansky (Data Egret)
    Input-output performance problems are on every day agenda for DBAs since the databases exist. Volume of data grows rapidly and you need to get your data fast from the disk and moreover - fast to the disk. For most databases there is a more or less easy to find checklist of recommended Linux settings to maximize IO throughput. In most cases that checklist is good enough.
    MySQL PostgreSQL Optimization
  • 12:50pm to 1:40pm
    Room 203
    • Developer
    Ed huang (PingCAP), Max Liu (PingCAP)
    TiDB is a NewSQL database and is compatible with MySQL. It's inspired by Google Spanner and Google F1. In this talk, I will address the following topics: 1. The scalability and performance of the latest TiDB. 2. How we make TiDB to be a hybrid database. 3. How we are making it 10x to 100x faster than MySQL in some complex queries. 4.
    MySQL Sharding Replication
  • 12:50pm to 1:40pm
    Room 204
    • Wildcard
    Jeremy Glick (ZipRecruiter), Andrew Moore (Percona)
    Join Jeremy Glick and Andrew Moore whilst they share their experiences persuading MySQL to meet various regulatory compliance standards. Previous methods of logging for compliance included UDFs, triggers and other unreliable means to fill a gap in the core offering.
    MySQL

1:50pm to 2:40pm

  • 1:50pm to 2:40pm
    Ballroom A
    • Operations
    • Developer
    George Lorch (Percona), Vladislav Lesin (Percona)
    Percona announced Percona Server with RocksDB engine. At the other hand Percona Server has TokuDB engine. Both engines are optimized for write workload. What's the difference between these two engines? This talk will compare TokuDB vs RocksDB from different aspects. We will start from algorithmic perspective and continue with benchmarking.
    RocksDB MySQL
  • 1:50pm to 2:40pm
    Ballroom C
    • Operations
    • Developer
    Dimitri KRAVTCHUK (Oracle)
    This session will be interesting to everyone looking for the latest news about MySQL Performance: - Overview of progress in MySQL Performance - The latest benchmark results obtained on the current MySQL dev version -vs- others - The latest improvements made in MySQL/InnoDB design, resolved contentions, new features and solutions - The latest findings in MySQL Performance tuning, workaround
    MySQL Tools and Techniques Monitoring
  • 1:50pm to 2:40pm
    Ballroom D
    • Developer
    Aleksandr Kuzminsky (Box, TwinDB), Troy Karraker (Box)
    For the last 5 years Box has been launching and managing various open source tools. In these years, there have been many hazards that have been avoided, interesting problems that have been solved, and many benefits provided to Box. We would like to share these stories with the community at large and ensure anyone is prepared to launch their own tools into the open source community.
    MySQL Tools and Techniques Programming
  • 1:50pm to 2:40pm
    Ballroom E
    • Business / Case Studies
    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 3 different choices and how the three different databases reacted on the different platforms used, both in resource management and performance.
    MariaDB MySQL Optimization
  • 1:50pm to 2:40pm
    Ballroom F
    • Developer
    Luis Soares (Oracle), Nuno Carvalho (Oracle)
    MySQL Group Replication is a new plugin that implements an exciting extension to the proven and long standing MySQL Replication technology.
    MySQL High Availability Replication
  • 1:50pm to 2:40pm
    Ballroom H
    • Operations
    Casper Kejlberg-Rasmussen (Uber)
    At Uber we have many thousands of MySQL databases running inside of Docker containers on thousands of hosts. When deciding exactly which host a database should run on it is important that you avoid hosts running databases of the same cluster as the one you are placing, that you avoid placing all databases of a cluster on the same rack or in the same data center.
    MySQL Tools and Techniques
  • 1:50pm to 2:40pm
    Room 204
    • Business / Case Studies
    Solomon Chang (Tivo)
    So you're trying to migrate your MySQL infrastructure to Cassandra. You've seen that Cassandra can use tables just like your favorite RDBMS, and even has a Query Language that looks functionally identical to SQL.
    MySQL Devops NoSQL
  • 1:50pm to 2:40pm
    Room 209
    • Operations
    • Developer
    Janis Griffin (SolarWinds, Inc)
    MySQL query tuning is often more art than science and it can quickly eat up a lot of time.
    MySQL Optimization Monitoring

3:00pm to 3:50pm

  • 3:00pm to 3:50pm
    Ballroom A
    • Developer
    Ike Walker (GitHub)
    In this session, I will discuss some of the practical uses of JSON in MySQL, focusing on version 5.7 but also discussing options for previous versions, and briefly discussing MySQL 8.0.
    MySQL Tools and Techniques Programming
  • 3:00pm to 3:50pm
    Ballroom B
    • Developer
    MC Brown (Continuent)
    No database is an island and as NoSQL and BigData provide additional challenges and opportunities, you need a way for information and data to be replicated between your existing MySQL, MariaDB or Oracle installation out to other databases.
    MySQL NoSQL Replication
  • 3:00pm to 3:50pm
    Ballroom C
    • Operations
    • Developer
    Rick James ((self))
    These are distilled from watching MySQL users -- from newbies to experts -- successfully (or unsuccessfully) tune, index, optimize, and query.
    MySQL Optimization Tools and Techniques
  • 3:00pm to 3:50pm
    Ballroom D
    • Operations
    David Turner (Uber), Ben Black (Tango)
    Whether adding indexes, altering enums, changing datatypes or reorganizing tables - there are right and wrong ways when production is involved.
    MySQL Tools and Techniques
  • 3:00pm to 3:50pm
    Ballroom F
    • Developer
    Alfredo Kojima (Oracle), Mike Zinner (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.
    MySQL Programming NoSQL
  • 3:00pm to 3:50pm
    Room 209
    • Operations
    • Wildcard
    Alawi Assaggaf (Fuze)
    Every DBA needs to be on top of the health status of all DB servers and their current configuration. However, there are many different solutions out there that are either costly, or simply do not provide all the options and features you are looking for.
    MySQL Metrics Monitoring