Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Schedule - Day 3 | Thursday 27 April 2017

Filter by Topics

Filter by Tracks

Thursday 27 April 2017
  • 9:00am to 9:10am
    None
    • Business / Case Studies
    Xinyao Hu
    In this talk, I will introduce Airbnb's change data change system, Spinaltap. I will briefly cover its design and then focus on various use cases inside Airbnb. These use cases cover both online serving production serving and offline large distributed batch processing.
    Web Services
  • 9:10am to 9:25am
    None
    • Business / Case Studies
    Peter Zaitsev
    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é
    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.
    Devops Ecommerce Metrics
  • 9:50am to 10:15am
    None
    • Business / Case Studies
    Emily Slocombe, Daniel Nichter
    The MySQL Community Awards initiative is an effort to acknowledge and thank individuals and corporations for their contributions to the MySQL ecosystem. It is a from-the-community, by-the-community and for-the-community effort. Awards are given for Community Contributor, Application, and Corporate Contributor. More information can be found here: http://mysqlawards.org
    Fundamentals

11:00am to 11:50am

  • 11:00am to 11:50am
    Ballroom A
    • Developer
    wei hu, dengcheng he
    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 Redo 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
    Yngve Eriksson, Kushal Shah, Stacy Yuan
    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
    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
    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
    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
    Frédéric Descamps, René Cannaò
    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
    Ballroom G
    • Business / Case Studies
    • Wildcard
    Ryan Lowe, John Cesario
    Neo4J is rapidly becoming a force multiplier within organizations with highly connected data. The purpose of this talk is to enumerate the good, bad, and ugly that we have learned about Neo4J as we have deployed it within Square and made it a first class citizen.
    Other OSDB Fundamentals
  • 11:00am to 11:50am
    Room 203
    • Operations
    Alex Coomans, Dan Ni
    How do you surface important metrics across your infrastructure when needed most when you've got thousands of machines and each of those has thousands of metrics? Maintaining distributed collection systems with centralized storage and query layers, all with a desired uptime of 100% can be challenging.
    Other OSDB Devops Metrics
  • 11:00am to 11:50am
    Room 204
    • Operations
    • Developer
    Andrew Moore
    Today we administer so much data. From traditional RDBMS and NoSQL data. Then there is all the data from stack traces, messages in log files, and that's before we start to consider all the noise that IoT presents to us. Join me as I show you how you can bring this all together with Elastic Stack.
    Monitoring Tools and Techniques
  • 11:00am to 11:50am
    Room 209
    • Operations
    • Developer
    Patrick McFadin
    Cloud competition is heating up and the real winner is going to be you! Run your workloads wherever the price is right and avoid the dreaded cloud lock-in. The real trick is finding a way to co-exist in multiple clouds or even cloud and data center. Having a reliable and consistent data isn’t an easy problem to solve but I can show how to do it.
    Other OSDB Data in the Cloud Replication
  • 11:00am to 11:50am
    Room 210
    • Business / Case Studies
    Jean-François Gagné
    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
    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
    Peter Boros, Károly Nagy
    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.
    Devops Tools and Techniques MySQL
  • 12:50pm to 1:40pm
    Ballroom C
    • Developer
    Bill Karwin
    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 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
    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 G
    • Operations
    • Developer
    Ilya Kosmodemiansky
    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
    Ballroom H
    • Operations
    • Developer
    Sandeep Dinesh
    Last year, I talked about running databases with containers. The benefits were clear, but the actual operations were messy. With the introduction of StatefulSets in Kubernetes, databases finally get first class support! There is no longer a need to mess around with deployment scripts, and manually managing the underlying infrastructure is a thing of the past.
    MongoDB Devops Data in the Cloud
  • 12:50pm to 1:40pm
    Room 203
    • Developer
    Max Liu, Ed huang
    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
    Andrew Moore, Jeremy Glick
    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
  • 12:50pm to 1:40pm
    Room 209
    • Business / Case Studies
    Kisung Kim
    Recently, graph data is emerging everywhere including manufacturing industries, biological databases, heath cares, network device information, fraud detection, IOT, logistics and social networks. Traditionally, graph data is considered to be hard to process in relational databases because they have highly connected relationships.
    Other OSDB
  • 12:50pm to 1:40pm
    Room 210
    • Business / Case Studies
    Brett Hesterberg
    Get the most from Google Cloud SQL: Google's fully-managed database service that makes it easy to set up and maintain your relational databases in the cloud. In this session, we'll show you how to scale performance and securely connect to Cloud SQL from anywhere in the world.
    Other OSDB

1:50pm to 2:40pm

  • 1:50pm to 2:40pm
    Ballroom A
    • Operations
    • Developer
    Vladislav Lesin, George Lorch
    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.
    MySQL RocksDB
  • 1:50pm to 2:40pm
    Ballroom B
    • Operations
    • Wildcard
    Josh Snyder
    Queues are essential to software systems, present everywhere from MySQL to RollerCoaster Tycoon. Understanding these queues is key to achieving consistently high performance. In this session, we will consider many of queues involved in servicing database queries, and some of the queueing theory we can use to optimize them.
    Optimization Tools and Techniques Fundamentals
  • 1:50pm to 2:40pm
    Ballroom C
    • Operations
    • Developer
    Dimitri KRAVTCHUK
    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
    Troy Karraker, Aleksandr Kuzminsky
    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
    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
    Nuno Carvalho, Luis Soares
    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 G
    • Developer
    Stefan Negrea
    Hawkular Metrics is a scalable, long-term, high performance storage engine for metric data. This session is an overview of the project that includes: history of the project, an overview of the Hawkular ecosystem, technical details of the project, developer features & APIs, and third party integrations.
    Tools and Techniques Time Series Metrics
  • 1:50pm to 2:40pm
    Ballroom H
    • Operations
    Casper Kejlberg-Rasmussen
    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 203
    • Operations
    • Developer
    Björn Rabenstein
    Prometheus is an open-source monitoring and alerting system that has quickly gained popularity over the last two years (which includes sophisticated monitoring of MySQL database servers). One of the components of Prometheus is a time-series database (TSDB) embedded into the monitoring server. The TSDB uses a highly domain-specific query language called PromQL.
    Other OSDB Time Series Metrics
  • 1:50pm to 2:40pm
    Room 204
    • Business / Case Studies
    Solomon Chang
    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
    MySQL query tuning is often more art than science and it can quickly eat up a lot of time.
    MySQL Optimization Monitoring
  • 1:50pm to 2:40pm
    Room 210
    • Business / Case Studies
    Ajay Kulkarni
    Time-series databases are the fastest growing category in databases today. We even held a keynote panel discussing some of the options earlier in the conference. But what exactly is "time-series data"? And why do we need a special database to handle it?
    Data as a Service Other OSDB

3:00pm to 3:50pm

  • 3:00pm to 3:50pm
    Ballroom A
    • Developer
    Ike Walker
    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
    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
    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
    Ben Black, David Turner
    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 E
    • Wildcard
    Kenny Gryp, Ramesh Sivaraman
    What are the implementation differences between Percona XtraDB Cluster 5.7, Galera Cluster 5.7 and MySQL Group Replication? - How do each of these work? - How do they behave differently? - Are there any major issues with any of these? This talk will describe these differences and also shed some light on how QA is done for each of these different technologies.
    High Availability
  • 3:00pm to 3:50pm
    Ballroom F
    • Developer
    Mike Zinner, Alfredo Kojima
    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
    Ballroom G
    • Developer
    Richard Hipp
    SQLite is the most widely used and deployed database engine in the world with many billions of active installations. But SQLite is not a competitor to MySQL, PostgreSQL, SQL Server, or Oracle. SQLite solves a different problem and is complementary to those other technologies.
    Other OSDB Tools and Techniques Internet of Things
  • 3:00pm to 3:50pm
    Ballroom H
    • Operations
    Laine Campbell
    Data integrity is a core functional requirement driven by your business' requirements. Over the last decade, we’ve seen an explosion of distributed datastores (aka polyglot storage), including datastores managed for us as a service.
    Tools and Techniques Fundamentals Data in the Cloud
  • 3:00pm to 3:50pm
    Room 203
    • Operations
    • Developer
    Justin Teller
    In December 2016, the health and performance monitoring team at Facebook open sourced our in-memory time series database: Beringei. Beringei is different from other in-memory systems, such as memcache, because it has been heavily optimized for storing time series data used specifically for health and performance monitoring.
    Time Series Metrics
  • 3:00pm to 3:50pm
    Room 204
    • Operations
    • Developer
    Karthik Gandhi
    Traditionally, machines were statically partitioned across the different services at Uber. In an effort to increase the machine utilization, Uber has recently started transitioning most of its services, including the storage services, to run on top of Mesos.
    Data as a Service NoSQL High Availability
  • 3:00pm to 3:50pm
    Room 209
    • Operations
    • Wildcard
    Alawi Assaggaf
    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.
    Metrics Monitoring MySQL