Professional Cloud ArchitectDesign and plan a cloud solution architectureEasy
A company is migrating its on-premises PostgreSQL database to Google Cloud. The database is critical for business operations, requires high availability with automatic failover, and needs to be fully managed to reduce operational overhead. Which Google Cloud service should be chosen?
- ACloud Bigtable.
- BCloud Spanner.
- CCompute Engine with self-managed PostgreSQL.
- DCloud SQL for PostgreSQL.
Show answer & explanationAnswer & explanation
Correct answer: D. Cloud SQL for PostgreSQL.
Cloud SQL for PostgreSQL is a fully managed relational database service that provides high availability, automatic failover, and reduces operational overhead for PostgreSQL databases.
Why the other options are wrong
- A. Cloud Bigtable is a NoSQL wide-column database, not suitable for relational database migrations like PostgreSQL.
- B. Cloud Spanner is a globally distributed relational database, overkill for a standard PostgreSQL migration and a different database engine.
- C. Self-managing PostgreSQL on Compute Engine requires significant operational effort for high availability, backups, and maintenance.
Cloud SQL
A fully managed relational database service on Google Cloud that supports MySQL, PostgreSQL, and SQL Server.
- Managed relational database service
- Supports MySQL, PostgreSQL, SQL Server
- High availability with automatic failover
- Automated backups and patching
Memory trick: Cloud SQL is like a 'SQL butler' that manages your database for you.