Duration
4 days
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.
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
Programme scope, delivery arrangements and suitability are confirmed during enquiry.