Ensure that your Google Cloud MySQL database instances are using the latest major version of MySQL database in order to receive the latest database features and benefit from enhanced performance and security.
By upgrading your Google Cloud MySQL instances with the newer version of MySQL database, you will install new MySQL features and security patches, introduce performance improvements, and provide better compatibility with other cloud applications and services.
For MySQL, the first two numbers in the version number represent the major version number. For example, for version 5.7.25, Cloud SQL service uses 5.7 as the major version, and 25 as the minor version.
To determine if your Google Cloud MySQL database instances are using the latest major version of MySQL, perform the following operations:
Remediation / Resolution
MySQL database version cannot be automatically upgraded within Google Cloud Platform (GCP). To upgrade your Google Cloud MySQL instances to the latest major version of the MySQL database, you have to re-create the existing instance, export data from the existing (source) instance, and importing that data into a new (target) instance running the latest major version of MySQL. To implement the rule remediation/resolution process, perform the following operations:Note: Before moving your data to a database instance running a newer version of MySQL, you should familiarize yourself with the differences between the MySQL database engine versions.
- Google Cloud Platform (GCP) Documentation
- Cloud SQL for MySQL
- Database version policies
- Release notes
- Upgrading MySQL for an instance
- Exporting data from Cloud SQL
- Importing data into Cloud SQL
- Creating instances
- Deleting instances
Unlock the Remediation Steps
Gain free unlimited access
to our full Knowledge Base
Over 750 rules & best practices
You are auditing:
Check for MySQL Major Version
Risk level: Low