如何阻止Cloud SQL MySQL 5.7实例应用自动更新？

Hey there, I’ve dealt with this exact scenario before—those "Update/Done" records are Cloud SQL’s automatic maintenance updates (things like MySQL engine patches, security fixes, or underlying infrastructure updates). Here’s how you can stop them from running automatically:

Option 1: Use the Google Cloud Console #

• Log into your Google Cloud Console and navigate straight to your Cloud SQL instance’s dashboard.
• Hit the Edit button at the top of the instance details page to access configuration settings.
• Scroll down to the Maintenance section:
  • Look for the Auto updates toggle—flip this to Off. This will block Cloud SQL from automatically rolling out regular updates to your instance.
  • While you’re here, set a Maintenance window (even with auto-updates off, critical security updates might still need to run occasionally). Pick a time slot when your traffic is lowest to minimize disruption.

Option 2: Use the gcloud CLI #

If you prefer command-line tools, run this command to disable auto-updates for your instance:

gcloud sql instances patch YOUR_INSTANCE_NAME --no-auto-update

Just replace YOUR_INSTANCE_NAME with the actual name of your Cloud SQL instance.

Important Notes #

• Don’t skip manual updates: Disabling auto-updates means you’ll need to manually apply updates periodically. Keep an eye on Cloud Console notifications for critical security patches—ignoring these could put your instance at risk.
• Plan for downtime: When you do apply updates manually, schedule it during off-peak hours. Most updates require a short instance restart, which will cause brief downtime.
• Consider a version upgrade: MySQL 5.7 is nearing the end of standard support. If possible, plan an upgrade to MySQL 8.0 to get long-term support, better performance, and new features.

内容的提问来源于stack exchange，提问作者Rpj