Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Tutorials Schedule | Monday 24 April 2017

Filter by Topics

Filter by Tracks

Monday 24 April 2017

9:30am to 12:30pm

  • 9:30am to 12:30pm
    Ballroom A
    • Wildcard
    Dimitri Vanoverbeke, Tom De Cooman
    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.
    Fundamentals MySQL
  • 9:30am to 12:30pm
    Ballroom B
    • Operations
    • Developer
    Krunal Bauskar, Matthew Boehm
    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, Matthew Lord, Kenny Gryp
    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
    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
    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, Alexander Rubin
    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, Kim Wilkins
    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
    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
    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.
    MySQL RocksDB
  • 9:30am to 12:30pm
    Room 204
    • Developer
    Roshan Kumar, Adi Foulger
    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
    Dimitri Vanoverbeke, Tom De Cooman
    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.
    Fundamentals MySQL
  • 1:30pm to 4:30pm
    Ballroom B
    • Operations
    • Developer
    Matthew Boehm, Krunal Bauskar
    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
    Matthew Lord, Kenny Gryp, Frédéric Descamps
    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
    Derek Downey, René Cannaò, David Turner
    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
    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
    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
    Jason Terpko, Antonios Giannopoulos
    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
    Roma Novikov, Michael Coburn
    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
    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, Rick Golba, Jon Tobin
    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