Design a high-availability database architecture for an application that requires 99.99% uptime with zero data loss. Explain your component choices and trade-offs.

Sample answer preview

Designing for 99.99 percent uptime allows only 52.6 minutes of downtime per year, or about 4.4 minutes per month. Combined with zero data loss requirements, this demands a carefully architected solution with multiple layers of redundancy, automated operations, and rigorous…