Course Outline
Introduction
Installation and configuration of MariaDB
Overview of MariaDB architecture
Backup and restoration procedures for MariaDB
Point-in-Time-Recovery (PiTR)
Implementing security measures for MariaDB
Configuring MariaDB for high availability
Master-slave replication
Master-master replication
Configuring virtual IPs
Managing read/write distribution
Active-active clustering using Galera Cluster
Load balancing strategies
Performance tuning in MariaDB
Hardware considerations and performance
Schema optimization
Indexing techniques
SQL query tuning
Profiling
Closing remarks
Requirements
- Familiarity with basic MySQL or MariaDB operations
- Proficiency in the SQL language
- Experience using the Linux command line
Target Audience
- Developers
- Database administrators
- System administrators
Testimonials (4)
Exercises, balance between theory and practice
Damian Kajewski - Glosel Sp. z o. o. Sp. k.
Course - Advanced MariaDB for High Availability and Performance
trainers attitude
Krzysztof Halicki - Glosel Sp. z o. o. Sp. k.
Course - Advanced MariaDB for High Availability and Performance
I mostly enjoyed the knowledge about replication database.
Suparman - Universitas Terbuka
Course - Advanced MariaDB for High Availability and Performance
The trainer has extensive knowledge of IT.
