Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
28 Hours
Testimonials (2)
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.