Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Tutorials Schedule | Monday 24 April 2017

Sponsor Percona Live Open Source Database Conference

Filter by Topics

Filter by Tracks

Monday 24 April 2017

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
    Alexander Rubin (Percona), Sveta Smirnova (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 G
    • Operations
    David Murphy (Percona)
    MongoDB works well for people, but when it has issues the number one question is "where should I go to solve a problem?" We will be taking people through: -Example Segfaults -Reading of the error logs -Making sense of Server Status and each engines metrics -Understanding currentOp -Explaining how the sharding system works pre and post 3.4 -Ongoing analysis and maintenance recomm
    MongoDB Devops 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
  • 9:30am to 12:30pm
    Room 204
    • Developer
    Roshan Kumar (Redis Labs), Tague Griffith (Redis Labs)
    Redis enables your MySQL or MongoDB environment to grow in scale and complexity without compromising on your applications’ real-time needs. Redis is an ultra-high performing in-memory, NoSQL database platform commonly used as a database, cache, and message broker.
    Programming Fundamentals NoSQL
  • 12:30pm to 1:30pm
    None

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 G
    • Developer
    Antonios Giannopoulos (Rackspace), Jason Terpko (ObjectRocket by Rackspace)
    This tutorial will guide you through the many considerations when deploying a sharded cluster. We will cover the services that make up a sharded cluster, configuration recommendations for these services, shard key selection, use cases, and how data is managed within a sharded cluster. Maintaining a sharded cluster also has its challenges.
    MongoDB Optimization NoSQL
  • 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
  • 1:30pm to 4:30pm
    Room 203
    • Business / Case Studies
    Tal Levy (Elastic Search)
    Elasticsearch is a distributed, RESTful search and analytics engine. This workshop will cover foundational principles of search, and building a working search-engine application from scratch with the open source Elastic Stack (Elasticsearch, Logstash, Kibana, and Beats).
    NoSQL
  • 1:30pm to 4:30pm
    Room 204
    • Developer
    • Wildcard
    Barrett Chambers (Percona), Rick Golba (Percona), Jon Tobin (Percona)
    MongoDB is quickly becoming one of the NoSQL standards, but represents a very different way of thinking from traditional RDBMSs. Many database users tend to think of things from the perspective of the transactional DBs that they know and love, but there are other ways of doing things.
    MongoDB Fundamentals NoSQL