PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #72
During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your
The correct answer is C. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL. Google Cloud supports enabling HA on an existing Cloud SQL instance in-place using the gcloud sql instances patch command with the --availability-type=REGIONAL flag. This avoids the risk and complexity of data migration. Options A and B both require creating a new instance and mi
Question
During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?
Options
- ACreate a new Cloud SQL for MySQL instance, enable HA, and use the export and import option
- BCreate a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate
- CUse the gcloud instances patch command to update your existing Cloud SQL for MySQL
- DShut down your existing Cloud SQL for MySQL instance, and enable HA.
How the community answered
(38 responses)- A5% (2)
- B13% (5)
- C76% (29)
- D5% (2)
Explanation
Google Cloud supports enabling HA on an existing Cloud SQL instance in-place using the gcloud sql instances patch command with the --availability-type=REGIONAL flag. This avoids the risk and complexity of data migration. Options A and B both require creating a new instance and migrating data-unnecessary extra steps that introduce risk and downtime. Option D is incorrect because you cannot enable HA simply by shutting down the instance; HA requires a configuration change, not just a restart.
Topics
Community Discussion
No community discussion yet for this question.