How do you move a cloudsql instsance to a smaller disk?

[Jacob Peebles]

Hello,

We are looking for instructions on how to resize a CloudSQL DB. If anyone knows the steps to do this or a document/documentation on this it would be greatly appreciated.

Thanks,

Jake

[Katayoon (Cloud Platform Support)]

Hello Jacob,

My assumption is that you would like to resize either your instance storage or your instance machine type? If not, please provide more clarification on your question.

If you want to decrease your instance storage, you may take a look at this answer on Stack Overflow. You can also change your Machine Type via editing your instance.

[Jacob Peebles]

Yes, sorry for not adding enough detail. We would like to resize the storage to a smaller size.

- Jake

[Jacob Peebles @ Get.It]

Yes that is right. We would like to resize to smaller storage.

- Jake

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ac19dfd9-116c-4857-b3d0-f10dc62116bb%40googlegroups.com.

--

Thanks,

Jacob Peebles

CEO/Co-Founder

Get It® | https://www.get.it | ja...@get.it | 877.285.7861 x703

I'm on Linkedin | Twitter | Reddit | Youtube | Quora

[Jacob Peebles]

Hi All,

Bumping this back up? It would be great to have some guidance on how to do this. Again we have a Cloud SQL where our storage it outsized, to big so we want to move it to smaller storage. How do we do that?

Thanks!

- Jake

On Tuesday, May 19, 2020 at 11:02:32 AM UTC-4, Jacob Peebles wrote:

Yes that is right. We would like to resize to smaller storage.

- Jake

On Tue, May 19, 2020 at 9:40 AM 'Katayoon (Cloud Platform Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

Hello Jacob,

My assumption is that you would like to resize either your instance storage or your instance machine type? If not, please provide more clarification on your question.

If you want to decrease your instance storage, you may take a look at this answer on Stack Overflow. You can also change your Machine Type via editing your instance.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ac19dfd9-116c-4857-b3d0-f10dc62116bb%40googlegroups.com.

--

Thanks,

Jacob Peebles

CEO/Co-Founder

Get It® | https://www.get.it | jacob@get.it | 877.285.7861 x703

[Sabyasachi Sengupta]

As per the documentation of cloud sql, It does not seem you can do so.

https://cloud.google.com/sql/docs/mysql/instance-settings#storage-capacity-2ndgen

Data migration to a smaller instance
probably be the solution

[yananc]

Hi Jacob,

As Sabyasachi has pointed out in the doc, once the instance is created, the storage capacity cannot be decreased. The best option is to create a new instance with the desired capacity and then copy all the data of the old instance into it. The copying process could include exporting data to a CSV file and importing the file to the newly created instance.

Hope it helps!

[Jacob Peebles]

Yes, we are aware the storage capacity cannot be decreased, hence the question.

Thanks for those steps. This is a production DB that cannot be taken offline, is there another step to do a replication? Sorry if I left that point out.

- Jake