Online Training: MariaDB for MySQL DBAs

MariaDB for MySQL DBAs is a training for teams of DBAs who need to switch from MySQL to MariaDB. It is designed to be suitable for both new and expert DBAs. Experts can consider it a valuable resource to quickly learn what they need and ask for advice about their specific use cases.

The attendees will learn how to migrate from MySQL to MariaDB and which problems they may encounter. Then, they will learn how to user valuable MariaDB features that they will benefit from.

Objectives

  • Learn the most important differences between MariaDB and MySQL

    Certain operations need to be performed differently in MariaDB. Trying to use MariaDB without knowing these differences can cause many failures and headaches.

  • Administer MariaDB taking advantage of its unique features

    MariaDB has several optimisations and convenient functionalities that are not in MySQL. MariaDB DBAs should know them.

  • Learn how to migrate a database from MySQL to MariaDB

    Migrating a MySQL database to MariaDB requires special attention is we want to avoid a service disruption, or if the dataset is large.

  • Administer mixed MariaDB/MySQL environments

    Different applications may use different DBMSs, handled with the same tools. Or MariaDB could replicate data from MySQL.

Topics

  • Migrating from MySQL to MariaDB
  • Incompatibilities between MariaDB and MySQL
  • Dealing with syntax incompatibilities
  • MariaDB features: an overview
  • Backups
    • Available backup methods
    • Mariabackup
    • Binary log and Flashback
  • Replication
    • GTID
    • Attaching a MariaDB slave to a MySQL master
  • Running migrations in production (ALTER TABLE, DROP TABLE)
  • MariaDB storage engines
    • Storage engines overview
    • Aria storage engine for internal temporary tables
    • MariaDB CONNECT
  • Data encryption at rest
  • Column compression
  • MariaDB Temporal Tables (system-versioned, application-time)
  • MariaDB SQL syntax: INTERSECT, EXCEPT, VALUES, RETURNING
  • Invisible columns, sequences

On request, one or two of these topics can be replaced by other MariaDB features, as long as the instructor considers this reasonable.

Requirements

The course is designed for MySQL 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 for MySQL DBAs 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