AdvancedSystem-Design
45 min
Design a Cross-Region Database Replication System
DatabasesReplicationConsistencyDisaster Recovery
Advertisement
Interview Question
Design a database system that replicates across regions with low latency, conflict resolution, and disaster recovery.
Key Points to Cover
- Replication models: async, semi-sync, sync
- Conflict resolution: last-write-wins, CRDTs, app-level
- Disaster recovery: failover, RTO/RPO objectives
- Topology: active-active vs active-passive
- Monitoring and observability for replication lag
Evaluation Rubric
Clear replication models & trade-offs25% weight
Effective conflict resolution25% weight
Robust disaster recovery strategy25% weight
Operational observability & SLAs25% weight
Hints
- 💡Be explicit about RPO and RTO goals.
Potential Follow-up Questions
- ❓How do you handle schema migrations?
- ❓How do you test failover safely?
Advertisement