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.
Topics:
- 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.

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

Speakers

Kenny Gryp
Principal Consultant, Percona
Biography: 
Kenny is currently a Consultant at Percona. Bitten somewhere in the late 90s by the open-source bug, most of his spare time was spent working with Linux & OpenBSD servers. Eventually, after school ended, Kenny turned into a linux system administrator and performed that role at various companies. Before joining Percona, he worked at a large social networking company in Europe as DBA & Puppeteer.
Frederic Descamps
Consultant, Percona
Biography: 
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
Biography: 
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.

Slides