QuestionQ101

VerifiedDeploy scalable and highly available databases in Google Cloud

You are migrating your company’s critical ecommerce platform from an on-premises PostgreSQL database that uses PostgreSQL stored procedures to a highly available solution on Google Cloud. The platform requires extremely low downtime (Recovery Time Objective (RTO) – 5 minutes) and minimal data loss (Recovery Point Objective – 30 seconds). The platform serves a global customer base with peak traffic spread across multiple continents, while the primary transactional data must remain in a single geographic region for regulatory compliance. You need to design a cloud database solution that satisfies the RTO/RPO requirements while optimizing global read access and local transactional integrity. What should you do?

Explanation

AlloyDB provides PostgreSQL compatibility and high availability through active and standby primary nodes in different zones with automatic failover, supporting rapid recovery for the in-region transactional workload. Its cross-region replication creates asynchronously updated, read-only secondary clusters that reduce latency and scale reads for users in other regions, while the writable primary and transactional integrity remain in the required single region. The secondary cluster can be promoted for disaster recovery.

Learn more

Community Discussion

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