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