In this lab, you will design and implement a high availability database architecture using Google Cloud SQL. You will configure read replicas and failover replicas to ensure continuity and high availability across regions. This hands-on experience will provide practical insights into setting up a multi-regional HA architecture, understanding the performance implications, and managing failover processes effectively.
A fintech company requires a highly available database solution to ensure consistent service delivery across North America. The database should sustain 99.99% uptime, handle 5000 queries per second at peak times, and be resilient to regional outages. The solution must efficiently route read requests to replicas to optimize load.
