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

Upcoming Sessions:

• Orlando, Florida, USA
  Begins Monday, June 11, 2012
• Raleigh, North Carolina, USA
  Begins Monday, June 18, 2012
• Boston, Massachusetts, USA
  Begins Monday, July 9, 2012
• Chicago, Illinois, USA
  Begins Monday, July 9, 2012
• Los Angeles, California, USA
  Begins Monday, July 23, 2012
• Seattle, Washington, USA
  Begins Monday, August 6, 2012
• Phoenix, Arizona, USA
  Begins Monday, August 20, 2012
• Toronto, Ontario, Canada
  Begins Monday, August 27, 2012

Subscribe to upcoming training events: RSS feed