Training: MariaDB for MySQL DBAs

MariaDB for MySQL DBAs is a training for DBAs who want to switch from MySQL to MariaDB. It is designed to be suitable for both new DBAs and expert DBAs. Experts can consider it a valuable resource to quickly learn what they need and ask an 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.

Allow me to point out, as a reference, that I wrote that book Mastering MariaDB in 2014 and I was one of MariaDB Community Ambassadors.

Important notice:

Because of the global health situation,
currently all Federico-Razzoli.com services take place remotely.
This includes remote courses.

Topics

  • Migrating from MySQL to MariaDB
  • Attaching a MariaDB slave to a MySQL master
  • Incompatibilities between MariaDB and MySQL
  • Dealing with syntax incompatibilities
  • MariaDB features: an overview
  • Mariabackup
  • ALTER TABLE in production
  • MariaDB GTID
  • MariaDB storage engines
  • Aria storage engine for internal temporary tables
  • MariaDB CONNECT
  • Data encryption at rest
  • Column compression
  • MariaDB system-versioned tables (AKA temporal tables)
  • New SQL: INTERSECT, EXCEPT, VALUES
  • Invisible columns, sequences

On request, one or two of these items can be replaced by other MariaDB features.

Proprietary software distributed by the MariaDB company will not be covered by this course.

Objectives

Attendees will learn the most important differences between MariaDB and MySQL, and will gain the necessary skills to administer MariaDB servers taking advantage of unique MariaDB features. They will also learn how to perform migrations to MariaDB, and how to administer an environment where both MariaDB and MySQL are present.

Requirements

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

Attendees are strongly encouraged to bring their laptops with MySQL installed. For exercises and examples, the recommendation is to use mysql or mycli command-line interface.

If your company is going to host the course, please be sure that a projector and a whiteboard are in the room.

Cost and timing

The MariaDB for MySQL DBAs training has a cost of 1,200GBP and its duration is 2 days.

If the training is not remote and does not take place in London, Europe, the cost of travel and accommodation will be added to the total.

Request a course

To request a course or ask for more information, please contact me:

info@federico-razzoli.com
+44 7739 427279 (London time)
Skype: fede.razzoli
Telegram: federico_razzoli

Or just fill the following form:

Related courses

Next steps:

← Back to Training List