Advanced MariaDB for High Availability and Performance

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

Audience

• 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

Introduction

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

Indexing

SQL query Tuning

Profiling

Closing remarks