Course contentsShow
← Cloud and Infrastructure
Lesson 2438 of 2,98952. Disaster Recovery and BackupFree lesson

Database Failover Mechanisms

Implement RDS Multi-AZ, read replicas promotion, or database-level replication for DR.

Database Failover Mechanisms

What you'll learn: How to implement automated database failover using RDS Multi-AZ, read replica promotion, and database-level replication to ensure business continuity during disasters.

The Core Challenge

When your primary database fails—whether from hardware failure, data corruption, or regional outage—your applications must seamlessly switch to a healthy replica without data loss or extended downtime. This is where database failover mechanisms become critical for achieving your RTO and RPO objectives.

Three Primary Approaches

RDS Multi-AZ Deployments

AWS RDS Multi-AZ maintains a synchronous standby replica in a different Availability Zone. When failure is detected (typically within 60-120 seconds), RDS automatically updates the DNS record to point to the standby. Think of this like having two identical offices—when one loses power, everyone immediately relocates to the backup location.

Key characteristics:

  • Synchronous replication (zero data loss)
  • Automatic failover
  • Same-region only
  • RPO: Near-zero; RTO: 1-2 minutes

Read Replica Promotion

Read replicas use asynchronous replication across regions. During a disaster, you manually (or via automation) promote a read replica to become the new primary. This is like having branch offices that receive updates periodically—if headquarters goes down, you designate a branch as the new headquarters.

Trade-offs:

  • Cross-region capability
  • Potential data lag (seconds to minutes)
  • Requires manual or scripted intervention

Database-Level Replication

Native database replication (PostgreSQL streaming replication, MySQL binlog replication) gives you granular control over topology and failover logic. You manage the orchestration, typically using tools that monitor health and trigger promotions.

Key Takeaway: Database failover combines replication technology (Multi-AZ, read replicas, or native DB replication) with detection and promotion logic to automatically or manually redirect traffic to healthy database instances, balancing your RPO/RTO requirements against complexity and cost.