Problem Statement
Describe a simple high availability plan for a database in your HLD.
Explanation
Use a primary with at least one replica in a different zone. Enable synchronous or semi-sync replication per RPO. Health checks drive automatic failover via a coordinator or managed service.
Test failovers. Make app connections use a discovery endpoint that flips during incidents. Keep idempotency in writers to survive retried transactions.
Code Solution
SolutionRead Only
DB endpoint -> read/write router -> primary/replicas
Practice Sets
This question appears in the following practice sets:
