3. Reliability & Disaster Recovery (HA/DR)
Patroni HA, InnoDB Cluster, Always On, replication lag, and verifiable PITR
Covers zero data loss backup and recovery strategies, high-availability clustering topologies (Patroni, InnoDB Cluster, Always On), split-brain mitigation, replication lag triage, and deterministic Docker disaster recovery drills.
Module Syllabus & Lessons8 Lessons
Click published lessons to start learning immediately. Upcoming lessons detail planned objectives below.
The Modern DBA Academy curriculum maps directly to dbaguide's battle-tested deep-dive articles, incident runbooks, diagnostic scripts, and architecture blueprints. Published items connect directly to their verified engineering resources.
Zero Data Loss Backup & Recovery Strategy
RPO/RTO objectives, physical vs. logical backups, continuous WAL archiving, and verified recovery drills.
- •Define business-aligned RPO and RTO thresholds for mission-critical relational workloads
- •Distinguish between logical exports and physical continuous Point-in-Time Recovery (PITR)
- •Establish automated, deterministic recovery testing as a mandatory compliance requirement
PostgreSQL Disaster Recovery Restore Drill Lab
10-stage isolated Docker disaster recovery lab validating schema parity, global roles, and checksum consistency.
- •Spin up isolated source and target instances via single test command (`npm run test:drill`)
- •Resolve missing role errors during restore using pg_dumpall --globals-only
- •Verify database consistency using 7 deterministic checks (row counts, financial sum, MD5 checksum)
PostgreSQL Patroni + etcd + HAProxy HA Architecture
Distributed consensus (etcd), Patroni daemon mechanics, and HAProxy routing for automatic failover.
- •Configure leader election and split-brain fencing using a 3-node etcd cluster
- •Implement HAProxy health checks to route primary writes and replica read-only traffic
- •Execute controlled switchover and chaotic failover drills without application downtime
MySQL InnoDB Cluster + Group Replication Architecture
Group Replication Paxos consensus, MySQL Shell administration, and MySQL Router transparent routing.
- •Evaluate Single-Primary vs Multi-Primary Group Replication modes under write load
- •Deploy MySQL Router to transparently bridge application connection pools to cluster primary
SQL Server Always On Availability Groups Design
WSFC quorum configuration, synchronous/asynchronous commit modes, and AG listener routing.
- •Mitigate split-brain risk using WSFC quorum and cloud/file share witnesses
- •Configure Always On Availability Group listeners with transparent read-only routing
18-Point Disaster Recovery Drill Checklist
Pre-drill verification, incident simulation, restoration, and data integrity checklist.
- •Execute a compliant 18-step disaster recovery drill protocol for enterprise audit readiness
- •Benchmark and report Recovery Time Objective (RTO) with minute-level precision
PostgreSQL WAL Accumulation & Disk Filling Emergency Triage
Resolving runaway pg_wal disk growth caused by archiving failures or inactive replication slots.
- •Prevent database crash when pg_wal volume approaches 100% capacity
- •Drop stuck inactive replication slots safely
PostgreSQL Replication Lag Triage and Resolution
Measuring standby byte and second lag, diagnosing network and I/O write bottlenecks.
- •Diagnose write lag via pg_stat_replication metrics
- •Resolve long-running query conflicts on read replica
Get notified about new lessons and labs in 3. Reliability & Disaster Recovery (HA/DR).
Receive instant updates whenever new engineering modules, emergency incident runbooks, diagnostic scripts, and one-command Docker drills are published.