PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #141
You are building the database layer for a multinational ticketing marketplace on Google Cloud. Traffic is unpredictable and can spike by 8x during global presales and seasonal campaigns. The system…
The correct answer is C. Cloud Spanner with multi-regional configuration and SSD storage. Cloud Spanner multi-region is the only option that satisfies all four requirements together: (1) Strong consistency via TrueTime-based external consistency for ACID transactions; (2) Sub-second reads on three continents because replicas are colocated with users; (3) 99.999%…
Question
You are building the database layer for a multinational ticketing marketplace on Google Cloud. Traffic is unpredictable and can spike by 8x during global presales and seasonal campaigns. The system must deliver strongly consistent transactions, sub second reads for users on three continents, and a 99.999% availability target while still keeping spend under control. Which Google Cloud database service and configuration should you choose to meet these goals?
Options
- ACloud Bigtable with multi-cluster replication across two regions
- BCloud SQL for PostgreSQL with regional HA and cross-region read replicas using SSD
- CCloud Spanner with multi-regional configuration and SSD storage
- DCloud Firestore in Native mode with regional configuration
How the community answered
(41 responses)- A10% (4)
- B24% (10)
- C61% (25)
- D5% (2)
Explanation
Cloud Spanner multi-region is the only option that satisfies all four requirements together: (1) Strong consistency via TrueTime-based external consistency for ACID transactions; (2) Sub-second reads on three continents because replicas are colocated with users; (3) 99.999% SLA-Spanner's multi-region configuration is the only Google Cloud database with a five-nines availability guarantee; (4) Automatic, near-linear scaling to absorb 8x spikes without manual intervention. Bigtable lacks ACID transactions. Cloud SQL cannot achieve 99.999% globally. Firestore in Native mode does not match Spanner's transactional capabilities or SLA.
Topics
Community Discussion
No community discussion yet for this question.