CODEWITHSUNDEEP
mysqlgoogle-cloud-platformgoogle-cloud-sql
lookbackatit_
lookbackatit_

Reputation: 37

Cloud SQL resize would make me lose data?

We currently have a database hosted in Google Cloud SQL. We are paying almost 100$ but we use less than 5% of our size. Our configs are:

I was thinking of switching to Machine Type High Memory to Lightweight.

Would this delete my current database data?

Upvotes: 1

Views: 1280

Answers (1)

guillaume blaquiere
guillaume blaquiere

Reputation: 75790

You can scale up and down the memory and te CPU without data loss. Your database will be unavailable (you need to stop and to start it again with the new machine type configuration). Don't be afraid, you can do this

At, the opposite, you can scale up but not to scale down the storage capacity. If you want to achieve that, you need to export the data outside of your database, to delete the current Cloud SQL instance and to create a new one with a smallest disk. And then to reimport the data.

Upvotes: 3

Related Questions