Database failover drill

Overview

High-risk change — requires approvals and a maintenance window when possible.

Controlled or emergency promotion of read replica / standby.

Step checks

1. 1

   Pre-checks

   Replication lag, connection limits, backup snapshot age.

2. 2

   Execute

   Follow provider runbook; verify read/write endpoints.

3. 3

   Post-verify

   Synthetic transactions + app smoke; document RTO/RPO observed.