Operational DBA in a nutshell! Hands On Tutorial!

1 April 1:30PM - 4:30PM @ Ballroom B

Experience level: 
6 hours tutorial
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. On each of the various topics some slides will be presented, but the goal is to have YOU, as the student, work on a MySQL environment as much as possible. What will we cover? Almost every aspect of being a MySQL DBA! - First, we will install MySQL and configure the right privileges for your system. - Once we have a database running, we need to understand better what our database is doing. We will explain and look at the different possible diagnostics and monitoring options in MySQL. - We will even troubleshoot some issues which will be simulated on your individual test environment! - Not losing any data is an important goal for a MySQL DBA. we will discuss and try some of the different backup options. - One of the commonly used features in MySQL is it's built-in Replication. We will setup replication to another machine and verify consistency between master and slave. - Day-to-day MySQL DBA Operations like schema changes and optimizing the configuration will be done. VirtualBox images will be provided to do the hands-on exercises on your own laptop. This requires you to have at least +10GB of disk space available as well as at least 1GB of RAM available. In order to make this day as smooth as possible, we are making extensive use of VirtualBox snapshots. This will allow you step back and forward to any chapter in the course in case you got stuck or if you would like to play with it some more in the future. Prerequisites: - Be familiar with MySQL's basic usage (starting, stopping, basic command line tools like 'mysql', 'mysqld', 'mysqldump') - Have some familiarity with SQL - Be used to working with unix shells and SSH - Have a laptop with virtualbox installed and working


Head of Technical Account Management, Percona
Liz joined Percona after spending 5 years as a performance consultant for a University research lab in Belgium. During this time, she spent most of her days measuring and trying to reduce the impact of virtualized environments all across the software stack. Optimizing software became something of an obsession, and MySQL found its special place in her heart soon after. Liz has spoken and led tutorials on DBA best practices multiple times at past Percona Live events.
MySQL Practice Manager, Percona
Kenny is currently MySQL Practice Manager at Percona.
Solution Engineer, Percona
At the age of 7, Dimitri received his first computer, since then he has felt addicted to anything with a digital pulse. Dimitri has been active in IT professionally since 2003 in which he took various roles from internal system engineering to consulting. Prior to joining Percona, Dimitri worked as a Open Source consultant for a leading Open Source software consulting firm in Belgium. During his career, Dimitri became familiar with a broad range of open source solutions and with the devops philosophy. Whenever he's not glued to his computer screen, he enjoys travelling, cultural activities, basketball and the great outdoors. Dimitri is living with his girlfriend in the beautiful city of Ghent, Belgium.