Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Schedule - MySQL 101 - Tuesday - 4/25/2017

Sponsor Percona Live Open Source Database Conference

  • 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 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 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. This is your soup to nuts talk that will have you going from zero to hero in no time, including best practices for installation, configuration, taking backups, monitoring, etc.
    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: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
    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. However there are many contenders and depending on the type of use case you might benefit from TokuDB or MyRocks, engines that are included in Percona Server for MySQL. Learn when to use the right engine for the job.
    MySQL
  • 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