QuestionQ127

Designing scalable, available, and reliable cloud-native applications

HipLocal wants to increase the resilience of its MySQL deployment while continuing to meet its business and technical requirements.

Which configuration should it select?

  • A Use the current single instance MySQL on Compute Engine and several read-only MySQL servers on Compute Engine.
  • B Use the current single instance MySQL on Compute Engine, and replicate the data to Cloud SQL in an external master configuration.
  • C Replace the current single instance MySQL instance with Cloud SQL, and configure high availability.
  • D Replace the current single instance MySQL instance with Cloud SQL, and Google provides redundancy without further configuration.
Explanation

Cloud SQL is a fully managed MySQL service that reduces database administration. Configuring it for high availability creates a regional deployment with redundant capacity across zones and automatic failover, protecting the database from zonal and instance failures. High availability is an explicit configuration; a standard Cloud SQL instance is otherwise zonal and does not automatically recover from a zonal outage.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!