MySQL DBA Training Courses from Percona

An intensive one-day workshop 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.

Attendees of this workshop will be able to:

• 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.

Prerequisites:

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 course first.

Format:

This course is delivered as a one day intensive. Attendees will be provided with Linux PCs, but given the time restrictions, hands-on exercises will be limited. Attendees are encouraged to use their own laptops if they prefer. Slides will be provided for students wishing to apply additional study after the course is complete.

Students wishing to practice skills learned in a more hands on environment are encouraged to stay for our operations training course.

Applies to MySQL Versions:

MySQL and Percona Server versions 5.0 and newer