Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Schedule - Day 3 | Thursday 27 April 2017

Sponsor Percona Live Open Source Database Conference

Filter by Topics

Filter by Tracks

Thursday 27 April 2017
  • 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
  • 9:50am to 10:15am
    None
    • Business / Case Studies
    Emily Slocombe (SurveyMonkey)
    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 (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
    Ballroom G
    • Business / Case Studies
    • Wildcard
    Ryan Lowe (Square, Inc.), John Cesario (Square, INC)
    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
    Ballroom H
    • Operations
    Brett Bertocci (Sysdig)
    I hate to say it, but there’s a lot of bad advice out there on how to monitor your containers in production. In this talk I hope to add some much-needed clarity on how to best monitor containers to manage the health of your applications.
    Devops Metrics Monitoring
  • 11:00am to 11:50am
    Room 203
    • Operations
    Dan Ni (Square), Alex Coomans (Square)
    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 (Percona)
    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.
    Tools and Techniques Monitoring
  • 11:00am to 11:50am
    Room 209
    • Operations
    • Developer
    Patrick McFadin (DataStax)
    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é (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
    Ballroom H
    • Operations
    • Developer
    Sandeep Dinesh (Google)
    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
    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
  • 12:50pm to 1:40pm
    Room 209
    • Business / Case Studies
    Kisung Kim (BitNine)
    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 (Google)
    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
    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 B
    • Operations
    • Wildcard
    Josh Snyder (Fitbit)
    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 (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 G
    • Developer
    Stefan Negrea (RedHat )
    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 (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 203
    • Operations
    • Developer
    Björn Rabenstein (SoundCloud Ltd.)
    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 (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 E
    • Wildcard
    Kenny Gryp (Percona), Ramesh Sivaraman (Percona)
    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
    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
    Ballroom G
    • Developer
    Richard Hipp (SQLite.org)
    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 (SolaceClub)
    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 (Facebook)
    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 (Uber)
    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 (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