Online Training: MariaDB Administration Essentials

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

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

Objectives

  • Understand MariaDB architecture

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

  • Administer MariaDB servers

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

  • Monitoring and troubleshooting

    Most MariaDB 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 MariaDB does not start, it is important to be able to act fast to restore the database.

Topics

  • MariaDB, MySQL, Percona Server: understand the characteristics of each solution
  • MariaDB architecture
    • Storage engines overview
    • InnoDB
    • Binary log
    • Error Log, Slow Log, General Log, SQL Error Log
  • Installing from packages or generic binaries
  • Basic configuration
  • Monitoring MariaDB with PMM
  • Basic performance tuning
  • Backup and restore
    • mysqldump
    • Copying files
    • Mariabackup
    • mysqlbinlog
  • 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 MariaDB stable version, or another version agreed with the customer before the beginning of the course. It is recommended that we use the MariaDB version they will use in their daily work.
  • mysql or mycli command-line interfaces. mysqli is bundled with MariaDB, 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 MariaDB version of choice.

Cost and timing

The MariaDB 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