DBA Training for MySQL
An intensive 8-hour course delivered over 4-days for MySQL database administrators and systems administrators that covers all of the tasks a DBA is responsible for including MySQL backups, replication, security and monitoring. The sessions are 2-hours of live virtual lecture per day followed by remote lab exercises. The workshop covers:
- Understand the differences between MySQL and forks - and which versions and editions should be run in production.
- Understand how various system components could be a bottleneck for MySQL: CPU, disks, memory, network; and how to use diagnostic tools in Linux.
- Investigate database trends via the counters exposed in MySQL's SHOW GLOBAL STATUS.
- Backup & restore MySQL and InnoDB data, and describe the advantages of common backup methods (mysqldump, file system snapshot, InnoDB hot backup).
- Setup MySQL replication, and describe how statement based replication works, and its limitations.
- Monitor MySQL servers in production.
- Discuss security issues with MySQL.
- Solve via case-study some real-life problems that Percona consultants faced in MySQL.
Who should attend:
Database Administrators and System Administrators who are responsible for MySQL servers.
We recommend prior experience with MySQL. The instructor assumes that every student is familiar with application instrumentation and how to optimize queries in MySQL. If you are not familiar with these two topics, we recommend that you attend our Developer Training for MySQL course first.
Applies to MySQL Versions:
MySQL and Percona Server 5.1 and newer