Advanced MariaDB for High Availability and Performance Training Course

Overview

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

Requirements

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

Audience

  • Developers
  • Database administrators
  • System administrators

Course Outline

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

Leave a Reply

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