An enterprise operations team manages a production Cloud SQL for MySQL instance that experiences unpredictable data volume growth. To prevent database downtime caused by running out of disk space, the cloud engineer needs to configure the instance so that its storage capacity expands automatically when free space drops below a critical threshold, without requiring manual instance restarts. Which action should the engineer take?
- Execute `gcloud sql instances patch INSTANCE_NAME --storage-auto-increase` to enable automatic disk capacity expansion.Answer
- BMigrate the relational workload to Cloud Bigtable, as it automatically manages relational schema disk expansion without storage limits.
- CMount a Cloud Storage bucket using the Coldline storage class to the database directory to serve as dynamic extension disk space.
- DRun `gsutil storage bucket update gs://INSTANCE_NAME --auto-extend-disk` to enable automatic disk expansion on the underlying storage bucket.
Answer
Execute `gcloud sql instances patch INSTANCE_NAME --storage-auto-increase` to enable automatic disk capacity expansion.
Executing the command to patch the Cloud SQL instance with the automatic storage increase flag configures Google Cloud to automatically expand persistent disk capacity whenever free space drops below threshold limits, preventing service failure without requiring instance downtime.
Step-by-Step Solution
Key Concept
Cloud SQL Storage Auto-Increase Management