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.
- Migrating from MySQL to MariaDB
- Incompatibilities between MariaDB and MySQL
- MariaDB features: an overview
- Available backup methods
- Binary log and Flashback
- Attaching a MariaDB slave to a MySQL master
- Running migrations in production (
ALTER ONLINE TABLE, LOCK, ALGORITHM, ignored indexes)
- 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)
- SQL statements implemented in MariaDB but not in MySQL
- 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.
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
- 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.