High Availability
Replication, clustering, failover, and database resilience strategies
13 canonical articles
MySQL Group Replication (2026): Multi-Primary HA, Conflict Resolution & Production Setup
Production-ready MySQL Group Replication deployment guide. Learn cluster sizing, monitoring setup, performance tuning, and disaster recovery planning.
MariaDB Galera Cluster Production Guide: Mariabackup, MaxScale & Schema Strategy
Production MariaDB Galera Cluster: mariabackup-based SST, MaxScale Galera-aware routing, schema-change strategy with TOI vs RSU, and a troubleshooting playbook for the failures that actually take down production.
Patroni with Consul DCS: PostgreSQL HA Without etcd
Configure Patroni to use Consul instead of etcd as its DCS for PostgreSQL HA. Covers Consul setup, patroni.yml, service discovery, HAProxy routing, and failover testing.
From Standalone to High Availability: Convert Your PostgreSQL Database to a Patroni Cluster
Learn how to convert a standalone PostgreSQL instance to a Patroni high-availability cluster with etcd. Step-by-step guide covering installation, configuration, and failover testing.
MySQL Orchestrator: Automated Failover and Topology Management
Set up MySQL Orchestrator for automatic failover, topology discovery, and master election at scale
Redis Sentinel vs Redis Cluster: Choosing the Right HA Architecture
Redis Sentinel and Redis Cluster both provide HA, but teams regularly choose the wrong one. Sentinel is simpler and covers 95% of use cases; Cluster is required for horizontal scale. Here's when to choose each.
PostgreSQL 17 Logical Replication: Failover Slots and Row Filtering
Logical replication in PostgreSQL has a critical gap: slots do not survive failover. PostgreSQL 17 finally fixes this with failover slots, plus adds row and column filtering for selective replication.
MySQL Group Replication vs Galera Cluster: A 2025 Comparison
MySQL Group Replication and Galera Cluster both promise multi-primary high availability, but they behave very differently under load, network partitions, and node failures.
MySQL Group Replication: Single-Primary Cluster Setup
Configure MySQL Group Replication (MGR) with Paxos-based consensus for fault-tolerant clustering. Covers prerequisites, bootstrap, joining nodes, and health monitoring.
PostgreSQL High Availability with Patroni and HAProxy
Design PostgreSQL HA with Patroni 4.1, a protected quorum DCS, HAProxy role checks, explicit durability choices, and rehearsed switchover and recovery.
Mastering MySQL Group Replication: The Road to Fault-Tolerant Databases
Build fault-tolerant MySQL clusters with Group Replication. Learn multi-primary vs single-primary modes, conflict resolution, network partitioning handling, and failover strategies.
MySQL Galera Cluster: Setup, Tuning, and Common Pitfalls
Set up MySQL Galera Cluster for synchronous multi-master replication — configuration, split-brain avoidance, and monitoring
MySQL InnoDB Cluster Explained: Complete Guide to High Availability
Deploy and operate MySQL InnoDB Cluster 8.4 safely with AdminAPI, Group Replication, Router, tested failover, and recoverable outage procedures.