Professional Cloud ArchitectDesign and plan a cloud solution architectureMedium
A financial services company is migrating a critical, highly transactional application to Google Cloud. The application requires extremely low latency access to a database, with consistent performance and high availability across multiple regions. It also needs to scale globally to handle millions of transactions per second. Which Google Cloud database service is most appropriate for this scenario?
- ACloud SQL for PostgreSQL
- BBigtable
- CFirestore in Datastore mode
- DCloud Spanner
Show answer & explanationAnswer & explanation
Correct answer: D. Cloud Spanner
Cloud Spanner offers unique capabilities that combine the benefits of relational databases (strong consistency, SQL queries) with horizontal scalability and global distribution, making it ideal for highly transactional, globally distributed applications requiring high availability and low latency.
Why the other options are wrong
- A. Cloud SQL is a regional, managed relational database and while highly available, it doesn't offer the global, horizontal scalability and multi-region consistency for millions of transactions per second that Spanner does.
- B. Bigtable is a wide-column NoSQL database designed for massive analytical and operational workloads, but it's not a relational database and doesn't provide strong transactional consistency across multiple rows/tables like Spanner.
- C. Firestore is a NoSQL document database, suitable for mobile/web applications, but lacks the strong consistency and relational capabilities typically required for critical financial transactions at this scale.
Cloud Spanner
A globally distributed, strongly consistent, and horizontally scalable relational database service designed for mission-critical applications.
- Combines benefits of relational databases with horizontal scalability.
- Offers strong consistency globally.
- Suitable for high-throughput, low-latency transactional workloads.
Memory trick: Choose your database wisely, based on consistency, scale, and query needs.