QuestionQ107

VerifiedDeploy scalable and highly available databases in Google Cloud

Your organization operates a production Cloud SQL for MySQL instance. The instance has 16 vCPUs and 104 GB of RAM and runs at 90%–100% CPU utilization for most of the day. You need to scale up the database by adding vCPUs with minimal interruption and effort. What should you do?

Explanation

Cloud SQL instance capacity is changed by updating the managed Cloud SQL instance configuration. gcloud sql instances patch supports patching an existing instance and provides CPU and memory settings for custom machine configurations; changing the machine type can require a restart, but it avoids creating and restoring a separate database. MySQL database flags do not allocate vCPUs, and gcloud compute instances update does not manage Cloud SQL instances.

Learn more

Community Discussion

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