Course Outline
Introduction
Installation and configuration of MariaDB
Understanding the MariaDB architecture
Strategies for backing up and restoring data in MariaDB
Implementing Point-in-Time Recovery (PiTR)
Enhancing MariaDB security
Configuring MariaDB for high availability
Master-slave replication setups
Master-master replication configurations
Setting up virtual IP addresses
Distributing read and write workloads
Active-active clustering using Galera Cluster
Implementing load balancing
Performance tuning techniques in MariaDB
Hardware considerations and performance impact
Schema optimization
Indexing strategies
Optimizing SQL queries
Database profiling
Closing remarks
Requirements
- Familiarity with basic operations of MySQL or MariaDB
- Proficiency in SQL language
- Experience with the Linux command line interface
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.
