MariaDB

A MariaDB-specific path covering SQL, InnoDB and alternative engines, optimizer behavior, replication, Galera Cluster, security, mariadb-backup, observability, upgrades, and production operations—including where MariaDB diverges from MySQL.

Browse curriculum Back to all courses

22chapters

110lesson paths

Intermediate → Advancedlearning level

Publishedcourse state

Coverage baselineMariaDB 11.8 LTS and the current innovation/LTS release model

Course brief

From engine fundamentals to advanced production operations.

This syllabus deliberately separates conceptual foundations, hands-on SQL, engine internals, operational tooling, reliability, security, performance, and capstone work so future lesson generation can go deep without compressing advanced subjects into generic chapters.

By the end

You will be able to

Use MariaDB confidently while recognizing important compatibility differences from MySQL
Design SQL, transactions, indexes, storage engines, and optimizer-aware workloads
Operate GTID replication and Galera Cluster with secure, tested failure handling
Back up and recover with mariadb-backup and binary logs under explicit RPO/RTO targets
Tune, secure, monitor, upgrade, and integrate MariaDB in production systems

Complete syllabus

22 chapters · 110 lessons.

Every lesson path was reserved in the planned syllabus and is now linked because its lesson HTML is available. The sequence moves from foundations through internals, advanced features, administration, reliability, security, tuning, upgrades, and a production capstone.

Chapter 1

MariaDB Foundations, Release Model, Editions, and Lab Setup

5 lessons

What MariaDB Is: Origins, Server Architecture, Ecosystem, and Common Deployment RolesPublished lesson · Chapter01/Lesson1.html

MariaDB

From engine fundamentals to advanced production operations.

You will be able to

22 chapters · 110 lessons.

MariaDB Foundations, Release Model, Editions, and Lab Setup

MariaDB vs MySQL: Compatibility, Divergence, and Migration Awareness

Server Architecture, Configuration, Connections, and Metadata

Schemas, Data Types, Keys, Constraints, and SQL Modes

SQL Querying, Joins, CTEs, Windows, and Analytical SQL

Data Modification, Transactions, Isolation, Locks, and Deadlocks

InnoDB in MariaDB: Storage, Buffering, Redo, Undo, and Recovery

MariaDB Storage Engines Beyond InnoDB

Index Design, FULLTEXT, Spatial, Vector, and Specialized Access Paths

Optimizer, EXPLAIN, Statistics, Histograms, and Query Tuning

Views, Stored Programs, Triggers, Events, and SQL/PSM

Accounts, Roles, Authentication, Authorization, and Security Hardening

Backup, mariadb-backup, Restore, and Point-in-Time Recovery

Asynchronous Replication, GTIDs, Parallel Apply, and Topology Design

Galera Cluster: Synchronous Multi-Primary Replication and High Availability

Partitioning, Large Tables, Online DDL, and Data Lifecycle

Performance Schema, sys Schema, Logs, and Observability

Performance Engineering: Memory, I/O, Threading, and Workload Tuning

Application Integration, Connectors, ORMs, Pools, and Reliability

Upgrades, Migrations, Compatibility Testing, and Low-Downtime Change

Advanced MariaDB Features: System-Versioned Tables, Oracle Mode, and Federation

Production Capstone: Design, Cluster, Secure, Tune, and Recover MariaDB