Course Outline
Introduction
Installation and configuration of MariaDB
Understanding MariaDB architecture
MariaDB backup and restoration procedures
Point-in-Time-Recovery (PiTR)
Implementing MariaDB security measures
Configuring MariaDB for high availability
Master-slave replication
Master-master replication
Virtual IP setup
Read/write distribution
Active-active clustering using Galera Cluster
Load balancing strategies
MariaDB performance optimization
Hardware considerations and performance
Schema tuning
Indexing techniques
SQL query optimization
Profiling
Concluding remarks
Requirements
- Familiarity with basic MySQL or MariaDB operations
- Proficiency in SQL language
- Comfort with the Linux command line
Target Audience
- Software 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.
