Course Outline
Introduction
Installing and configuring MariaDB
Overview of MariaDB architecture
Backing up and restoring MariaDB
Point-in-Time-Recovery (PiTR)
Securing MariaDB
Configuring MariaDB for high availability
Master-slave replication
Master-master replication
Setting up virtual IPs
Read/write distribution
Active-active clustering with Galera Cluster
Load balancing
Performance tuning in MariaDB
Hardware and performance
Schema tuning
Indexing
SQL query Tuning
Profiling
Closing remarks
Requirements
- Experience with MySQL or MariaDB basic operations
- Experience with SQL language
- Experience with Linux command line
Audience
- Developers
- Database administrators
- System administrators
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 6400 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.