Course Outline
Introduction
Deployment and configuration of MariaDB
MariaDB architectural framework
Backup and restoration procedures for MariaDB
Point-in-Time Recovery (PiTR)
MariaDB security protocols
Configuration of MariaDB for high availability
Master-slave replication implementation
Master-master replication configuration
VIP allocation and management
Distribution of read and write operations
Active-active clustering via Galera Cluster
Load balancing mechanisms
MariaDB performance optimization
Hardware specifications and performance metrics
Schema design optimization
Indexing strategies
SQL query optimization
Performance profiling
Closing remarks
Requirements
- Proficiency in fundamental MySQL or MariaDB operational procedures
- Competence in SQL query development and execution
- Familiarity with Linux command-line interfaces
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.