Duration
3 days
Objective
Tailored for the skilled database administrator, this class helps ensure high availability for mission-critical databases that can’t afford downtime. It teaches strategies for achieving high availability with MariaDB.
Prerequisite
None
Course Outline
Customer’s Objective:
- Intro about migrating to mariadb
- User and server security
- Backup and restore
- Server monitoring and logs and mariadb db audit logs
- Table partition
- Server variable and Sql modes
- Optimizing and tuning
- Maria DB galera cluster, mariadb max scale
- Maria DB Replication
- Storage engines
- Intro for mariab db column store (like architecture, managing column store, security vulnerability, performance tune)
Supplementary Syllabus:
- Installing and configuring MariaDB
Backing up and restoring MariaDB
- Point-in-Time-Recovery (PiTR)
- Maintenance and Crash Recovery
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
- Using SHOW STATUS
- Controlling MariaDB optimizer strategies
- Configuring threadpool
Profiling
Additional Topics
- Installation and upgrade
- Transaction logging and recovery methods
- Data Export and Import/load
- Defragmentation methods and update statistics
- User creation and DB privileges.
- Table Locking and Concurrency.
- Monitoring query performance & access plan
Programme scope, delivery arrangements and suitability are confirmed during enquiry.