Database Replication

Single-leader write path, follower setup, failover, split-brain prevention, and replication topologies

Synchronous, semi-synchronous, and asynchronous replication — per-operation consistency choices

Sync vs async replication, replication lag anomalies, read-your-writes, monotonic reads, routing, and replica promotion

Statement-based, WAL shipping, row-based logical replication, and trigger-based change capture