Professional Data Engineer

By Google · Question Mode

QuestionQ49

Storing the data

You intend to deploy Cloud SQL with MySQL. You must ensure high availability if a zone fails. What should you do?

Explanation

Cloud SQL high availability uses a primary and a secondary-zone standby within the same region, with automatic failover when the primary instance or its zone fails. For legacy MySQL HA terminology, this standby is called a failover replica. Read replicas do not provide the automatic failover capability required for zonal high availability.

Learn more

Community Discussion

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