Operational DBA In A Nutshell! Hands On Tutorial! (Part 1)

Database Administration
22 April 9:30am - 12:30pm @ Ballroom G

This is a full day tutorial

The tutorial is meant for people to gain more experience in day to day tasks to manage a MySQL Infrastructure.
Several best practises, techniques, tools will be explained and tested during this full day Tutorial.
- Monitoring (alerting & trending)
- Backups (strategy, XtraBackup, recovery)
- Performing Schema Changes
- Security
- Identify queries to optimize
- High Availability
- MySQL Configuration (best practises)
- Understand MySQL's behavior better (counters, innodb information, system resources)
- Investigating different kinds of problems (capturing, understanding resolving)
- Tools to make your life easier (percona toolkit…)
- Validating configurations (benchmarking)
- Replication (setup, consistency checks, fixing replication)

The tutorial will be mainly hands on. Virtualbox images will be provided at the start of the tutorial.

- 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


Kenny Gryp
MySQL Practice Manager, Percona
Kenny is currently MySQL Practice Manager at Percona.
Frederic Descamps
Senior Architect, Percona
Frédéric is an experienced Open Source consultant with expertise in infrastructure projects as well in development tracks and database administration. Frédéric is a believer of devops culture.
Liz van Dijk
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.