Advanced MariaDB for High Availability and Performance Training Course
Course
In City Of London
Description
-
Type
Course
-
Location
City of london
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.
Audience
Developers
Database administrators
System administrators
Format of the course
Part lecture, part discussion, exercises and heavy hands-on practice
Facilities
Location
Start date
Start date
Reviews
Subjects
- Database training
- Database
Course programme
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
Advanced MariaDB for High Availability and Performance Training Course
