A healthtech company is migrating an internal administrative tool to Google Cloud. The application requires a standard relational database with SQL transactions for a 50 GB dataset hosted in a single region. Primary business requirements are to minimize operational management overhead and baseline compute costs while providing high availability across zones. Which database solution best meets these requirements?
- Cloud SQL configured with high availability (HA) enabled across two zones in the target regionAnswer
- BCloud Spanner provisioned with a regional instance configuration across multiple availability zones
- CCompute Engine virtual machines running self-managed PostgreSQL with 3-year committed use discounts
- DGoogle Kubernetes Engine (GKE) cluster running a stateful PostgreSQL container with persistent disks
Answer
Cloud SQL configured with high availability (HA) enabled across two zones in the target region is the optimal choice.
Cloud SQL offers a fully managed relational database service ideal for single-region workloads up to several terabytes. Enabling high availability (HA) provides automatic cross-zone failover while keeping operational overhead low and maintaining cost efficiency for a 50 GB database.
Step-by-Step Solution
Key Concept
Selecting Cloud SQL over Cloud Spanner or self-managed database infrastructure for small-to-medium regional relational workloads minimizes cost and operational overhead.