Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Schedule - MySQL 101 - Tuesday - 4/19/2016

This is a 1-day MySQL 101 track led by Percona MySQL experts who will take attendees through the fundamentals of MySQL DBA tools and techniques. Ticket includes access to the keynotes, receptions and exhibit hall. The course is on April 19 (first full day of the conference). This course is not just for DBAs: developers are encouraged to attend to hone their database skills. Developers who code to match the scale the demands of the online community are both a resource and an investment.

11:30am to 12:20pm
Room 204
  • MySQL 101
  • Operations and Management
Michael Benshoof (Percona)
The goal of this talk is to review the key features that would be part of a schema review, including things such as largest tables, index issues and table activity.
MySQL
1:20pm to 2:10pm
Room 204
  • MySQL 101
  • Operations and Management
Michael Benshoof (Percona), Sveta Smirnova (Percona), Francisco Bordenave (Percona)
The question comes in from your primary stakeholders: "The application is slower than normal so it must be the database." Where do you start? Troubleshooting performance issues can be a bit tricky if you don't know what to look for and how to look at it. There are a lot of moving pieces that interact within a MySQL instance that may need your attention. In this session we will show you how we do it at Percona, what to monitor and track, what to check and how so you will learn about our secret sauce to improve MySQL performance.
MySQL
2:20pm to 3:10pm
Room 204
  • Architecture/Design
  • MySQL 101
Jervin Real (Percona), Michael Coburn (Percona)
Preventing downtime-causing emergencies in MySQL can be difficult because they are caused by complex combinations of several things going wrong. Efforts to be proactive may be sincere, but without knowledge of the causes of emergencies, they often fail to prevent further problems.
Tools and Techniques, Fundamentals, High Availability
3:50pm to 4:40pm
Room 204
  • MySQL 101
  • Scalability/Performance
Yves Trudeau (Percona), Matt Yonkovit (Percona)
Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both direct and indirect costs associated with allowing these unhealthy systems to continue to exist. Small performance improvements can lead to huge overall reductions in both direct costs and resource costs. During this session, we will show you how small gains in performance impact the cost of your infrastructure.
MySQL, Optimization, Fundamentals
4:50pm to 5:15pm
Room 204
  • MySQL 101
  • Scalability/Performance
Marco "The Grinch" Tusa (Percona)
After some years MySQL with Galera had become the most common solution when synchronous replication is needed. The cloud and EC2 in particular had being one of the most used platform to deploy successful MySQL/Galera installations.
MySQL, AWS, Data in the Cloud
5:15pm to 5:40pm
Room 204
  • Architecture/Design
  • MySQL 101
Michael Patrick (Percona)
We will discuss various topologies for achieving High Availability with MySQL such as Percona XTRADB Cluster, DRBD, MHA, MySQL Orchestrator, and others. Each solution has advantages and challenges. Attendees will gain a deeper understanding of how to choose the best solution for their needs while avoiding some of the pitfalls of making the wrong choices. Avoid the costly mistakes that commonly cause outages and lost revenue. Plus get the latest and greatest developments on the technologies!
MySQL, High Availability, Replication