Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member 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
Testimonials
The trainer has extensive knowledge of IT.
Iwan Susanto - Universitas Terbuka
I mostly enjoyed the knowledge about replication database.
Suparman - Universitas Terbuka
Related Courses
MySQL Database Administration
14 hours
MySQL Administration
28 hours
MySQL / Galera
21 hours
SQL Fundamentals
14 hours
SQL Advanced in MySQL
7 hours
SQL in MySQL
14 hours
MariaDB Database Administration
14 hours
Percona Server dla MySQL
14 hours
ProxySQL
14 hours
Python in Data Science
35 hours