MariaDB Galera Cluster Administration

Basic knowledge and experience as a MariaDB/ Percona/ MySQL Database Administrator

This course is intended for database administrators.

The course presents options for High-Availability solutions using Galera Cluster.

You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster.

Topic overview

• Why I need them and what are High-Availability solutions?
• Cluster concepts
• ​What is MariaDB Galera Cluster and what it offers to my organization?

Galera Cluster Management

• How to start with Galera - what should I now before installation?
• Architecture and functionality
• First steps - Installation
• Going deeper - Configuration and Set-up
• Almost like a pro - Administration
• Performance
• Operations and operation modes
• Upgrade Galera
• Backups and restoring
• ​Controlling state transfer between nodes

Load balancing

Monitoring

How to deal with Galera multi- master configuration

Advanced features

• Security
• Scalability
• Replication
• ​Advanced configuration