Advanced MariaDB for High Availability and Performance Training Course


28 hours (usually 4 days including breaks)


  • Experience with MySQL or MariaDB basic operations
  • Experience with SQL language
  • Experience with Linux command line


  • Developers
  • Database administrators
  • System administrators


MariaDB is a fork of MySQL and one of the most popular database servers.

In this instructor-led, live training, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.

Format of the course

  • Part lecture, part discussion, exercises and heavy hands-on practice

Course Outline


Installing and configuring MariaDB

Overview of MariaDB architecture

Backing up and restoring MariaDB

Point-in-Time-Recovery (PiTR)

Securing MariaDB

Configuring MariaDB for high availability

Master-slave replication

Master-master replication

Setting up virtual IPs

Read/write distribution

Active-active clustering with Galera Cluster

Load balancing

Performance tuning in MariaDB

Hardware and performance

Schema tuning


SQL query Tuning


Closing remarks

Leave a Reply

Your email address will not be published. Required fields are marked *