Duration
21 hours (usually 3 days including breaks)
Requirements
Basic knowledge and experience as a MariaDB/ Percona/ MySQL Database Administrator
Overview
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.
Course Outline
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