cloud SQL mysql 5.7 version upgrade

Does cloud SQL support mysql version upgrade from 5.7 to 8.0 ?

As I cannot see any solution OR do i need to create the new SQL machine running for MySQL 8.0 version and import my DB from old instance to new instance.

Anyone clear my doubts

1 Like

Hello @nikhildobriyal ,Welcome on Google Cloud Community.

technically yes, you can. Creator will ask you about InstanceID, provide instance name.

Check this tutorial form Official Google Docs about upgrade DB major versions:
https://cloud.google.com/sql/docs/mysql/upgrade-major-db-version-inplace


cheers,
DamianS
LinkedIn medium.com Cloudskillsboost

1 Like

Yeah I found these steps later after posting this question, So, I need to upgrade all instances individually whether it’s a master or a replica, And can you tell me how much time it will take if the DB size inside is around 20GB

1 Like

Tbh I have no idea. I’m not able tbh to estimate this ( ergo never measured this :grinning_face_with_smiling_eyes: )