This advanced lab guides you through designing a multi-regional architecture using Cloud SQL and Cloud Spanner to ensure high availability and disaster recovery for a fictitious financial services company. You will configure read replicas, set up backup and recovery procedures, and utilize SQL Insights to monitor and optimize performance. The focus will be on balancing availability, cost, and performance to meet strict SLA requirements.
You are working for a financial services company that requires a high-availability database architecture to support their global trading platform. The system must ensure a 99.99% SLA and handle burst loads up to 10,000 transactions per second during peak trading hours. Your team decided to implement Cloud SQL for PostgreSQL for transactional data and Cloud Spanner for seamless scaling and global consistency. A key project goal is cost management while maintaining required performance and reliability metrics.
