As per a related post from last week, we’re looking forward to Percona Live 2016 in Santa Clara, the go-to conference for MySQL & MongoDB users in particular, and open source database enthusiasts in general.

This year we’ve been given the opportunity to conduct a one-day tutorial based on our popular blog series ‘Become a MySQL DBA’. We’re reaching our 20th post in this series (the latest one is on trouble-shooting with pt-stalk) and are excited to be able to share that content and knowledge during this one day session in Santa Clara this month.

Art van Scheppingen

Our colleagues Art van Scheppingen and Ashraf Sharif will be walking participants through the content and practical exercises for about 6 hours spread across day 1 at Percona Live. The tutorial is scheduled to take place in Ballroom H. For more information, visit the Tutorials Schedule.

We look forward to seeing you there; and do come visit us at booth 308 in the exhibition hall as well!

Tutorial Description

Ashraf Sharif

Someone came to your desk and said: “You seem to know MySQL, can you take care of our database? It looks like it needs some love”. Does that sound familiar? Lot’s of DBAs have gone that way. At the beginning, you need to learn a lot about MySQL and how to operate it.

This hands-on tutorial is intended to help you navigate your way through the steps that lead to becoming a MySQL DBA. We are going to talk about the most important aspects of managing MySQL infrastructure and we will be sharing best practices and tips on how to perform the most common activities.

In this tutorial we are going to cover:

  • Monitoring and trending for your MySQL installation
  • What’s the most important to look after?
  • What tools to use?
  • How to ensure you are proactive in monitoring health of your MySQL?
  • How to diagnose issues with your MySQL setup?
  • Slow queries
  • Performance problems - what to look for?
  • Error logs
  • Hardware and OS issues
  • Backups
  • Binary and logical backup
  • What tools to use?
  • Most common maintenance operations
  • Schema changes
  • Batch operations
  • Replication topology changes
  • Database upgrades
  • How to prepare for an upgrade?
  • Performing minor and major version upgrades

We will provide a setup using virtuals where you can freely test upon.

Related Post