QuestionQ3

VerifiedDeploy scalable and highly available databases in Google Cloud

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance for use by 100 databases. Each database contains 80 tables migrated from your on-premises environment to Google Cloud. The applications that use these databases run in multiple US regions, and you must ensure low latency for both read and write operations. What should you do?

Explanation

A regional Cloud SQL HA configuration provides a primary and standby across separate zones, enabling automatic failover and preserving availability for writes. Cross-region read replicas in us-east1 and us-west1 place read capacity nearer to applications in those regions, which improves read latency while the HA primary handles writes in its configured region.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!