A enterprise team needs to host a standard relational database on Google Cloud for an internal application. The workload requires high availability within a single GCP region with automatic zonal failover, but it has modest traffic and does not require global horizontal scaling or multi-region replication. Which infrastructure solution should you choose to meet these high availability requirements with minimal operational overhead?
- Cloud SQL configured with regional high availability (HA) using automatic zonal failoverAnswer
- BCloud Spanner configured as a regional instance with multi-zone replication
- CGoogle Kubernetes Engine (GKE) running a self-managed relational database in a multi-zone StatefulSet
- DCompute Engine single virtual machine instance with automated Cloud Storage snapshots replicated over HA VPN
Answer
Cloud SQL configured with regional high availability (HA) using automatic zonal failover is the optimal solution.
Cloud SQL regional high availability (HA) provides fully managed primary and standby database instances deployed in separate availability zones within the same region. Synchronous data replication ensures zero-data-loss failover without manual intervention or managing infrastructure.
Step-by-Step Solution
Key Concept
Selecting managed cloud database services with regional High Availability (HA) failover