Topic 1 Question 100
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?
Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
Shut down your existing Cloud SQL for MySQL instance, and enable HA.
ユーザの投票
コメント(4)
- 正解だと思う選択肢: C
A and B are obviously wrong, but it's still a bit confusing with the last two: C -
gcloud instances patchis not complete, it should begcloud sql instances patch, so I would consider it to be wrong, if not the D - you can't edit your instance (i.e. enable HA) when it's shut down, you can only do it when instance is running, and then it will restart. So I'll go for C👍 5chelbsik2022/12/26 D: Shut down your existing Cloud SQL for MySQL instance, and enable HA.
👍 1pk3492022/12/24The correct option is C. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
Explanation:
Creating a new instance and migrating data can be time-consuming and disruptive to your application's availability. Shutting down the existing instance is not a recommended approach, as it will cause downtime for your application.
The recommended approach is to use the gcloud instances patch command to enable high availability on your existing Cloud SQL for MySQL instance. This command updates the instance's configuration to enable the failover replica, configure it, and enable automatic failover.
By following this approach, you can ensure minimal downtime, and your application can continue to operate during the process.
👍 1Hilab2023/02/27
シャッフルモード