Answer-first summary for fast verification
Answer: Issue a gcloud sql instances patch command to increase the number of vCPUs.
To scale up the database and add vCPUs with minimal interruption and effort, the best approach is to issue a gcloud sql instances patch command to increase the number of vCPUs. This method allows for the scaling of the Cloud SQL instance directly without the need for creating a new instance or restoring from a backup, thus minimizing downtime and effort. Option B is incorrect because MySQL database flags cannot be used to change the instance's hardware configuration. Option C is incorrect because the gcloud compute instances update command is used for Compute Engine instances, not Cloud SQL instances. Option D, while technically possible, involves more steps and potential downtime compared to the patch command, making it less efficient for the given requirement.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you scale up a production Cloud SQL for MySQL instance with 16 vCPUs and 104 GB RAM that consistently runs at 90-100% CPU utilization, while minimizing downtime and effort?
A
Issue a gcloud sql instances patch command to increase the number of vCPUs.
B
Update a MySQL database flag to increase the number of vCPUs.
C
Issue a gcloud compute instances update command to increase the number of vCPUs.
D
Back up the database, create an instance with additional vCPUs, and restore the database.
No comments yet.