Online Training: MySQL Administration Essentials

MySQL Administration Essentials is an introductive  team training for new DBAs, and for expert DBAs who are not familiar with MySQL.

The attendees will learn how to perform normal and extraordinary operations on MySQL, like new installations, upgrades, monitoring and backups. They will learn how to configure instances properly and troubleshoot the most common problems.

Objectives

  • Understand MySQL architecture

    Understand MySQL components and their functioning from a high-level perspective.

  • Administer MySQL servers

    Learn how to perform all ordinary operations on MySQL, including backups, migrations and upgrades.

  • Monitoring and troubleshooting

    Most MySQL problems can be foreseen and prevented with proper monitoring. When problems happen, a DBA should be able to fix them.

  • Disaster recovery

    If data is corrupted or MySQL does not start, it is important to be able to act fast to restore the database.

Topics

  • MySQL, Percona Server, MariaDB: understand the characteristics of each solution
  • MySQL architecture
    • Storage engines overview
    • InnoDB
    • Binary log
    • Error Log, Slow Log and General Log
  • Installing from packages or generic binaries
  • Basic configuration
  • Monitoring MySQL with PMM
  • Basic performance tuning
  • Backup and restore
    • mysqldump
    • Copying files
    • Xtrabackup
    • mysqlbinlog
    • Clone plugin
  • Recovering corrupted tables
  • Migrations in production (ALTER TABLE)
    • ALGORITHM and LOCK syntaxes
    • pt-online-schema-change
    • gh-ost
  • Upgrades

Requirements

The course is designed for DBAs or DevOps of any level.

All attendees should have a stable and reasonably fast internet connection. Having a backup connection to use in case of troubles is also desirable.

Attendees should have the following programs installed on their laptops:

  • The latest MySQL stable version, or another version agreed with the customer before the beginning of the course. It is recommended that we use the MySQL version they will use in their daily work.
  • mysql or mycli command-line interfaces. mysqli is bundled with MySQL, whereas mycli is an open source project.
  • A terminal that allows to run system commands.

The operating system of choice is not relevant, as long as it is not too old or too new to run the MySQL version of choice.

Cost and timing

The MySQL Administration Essentials training has a cost of 2,500 GBP and its duration is 2 days.

A maximum of 15 attendees is allowed, and we encourage customers to keep the number of attendees as low as 10. This allows a good level of interactivity, and ensures that every attendee can obtain the necessary support.

Get In Touch

Contact us to book this course for your team.

Contact Us