mariadb-replication-and-ha
Installation
SKILL.md
MariaDB Replication and High Availability
Last updated: 2026-06-24
MariaDB offers three tiers of replication depending on your consistency and availability requirements:
| Approach | Consistency | Failover | Best for |
|---|---|---|---|
| Standard async replication | Eventual | Manual or tool-assisted | Read scaling, backups, low-latency writes |
| Semi-synchronous replication | Eventual (same as async) | Manual or tool-assisted | Ensuring a replica received each commit before the client is acknowledged — bounds failover loss (lossless only with AFTER_SYNC) |
| Galera Cluster | Synchronous (multi-primary) | Automatic | Zero-data-loss HA, multi-datacenter writes |
Requires: GTID replication, semi-synchronous replication, and parallel replication (including
optimisticmode) are all built in and have been available since well before any currently-supported release — assume they are present on the 11.8 LTS baseline. Current LTS is 11.8 (GA May 2025).Default context: Assume MariaDB 11.8 LTS unless the user states another version. Features marked 12.x or 13.0 may be suggested when relevant (including as upgrade options), but always state the minimum version — do not present them as available on 11.8.