How to change database version of a Google Cloud SQL (Second Gen) instance?

0
votes

I have a large Google Cloud SQL (Second Gen) instance, and I would like to upgrade my database version from MySQL 5.6 to 5.7. But database version option is disabled on the edit instance form.

Why it is disabled, do i have to create a new instance then export and import existing database? My database is too large, and it will be a long downtime.

1
google-cloud-platform

1 Answers

1
votes

Per the Cloud SQL Migration docs, the only way to migrate versions is to export your data, and re-import into a new instance. The documentation mentions going from 5.5 to 5.6, but I would believe that going 5.6 to 5.7 would follow the same procedure.