Reducing disk size of the Cloud managed SQL PG instance

[PavelEmdin99]

Hi there. We need to reduce our SQL instance disk size. There is no way to do it via console. According to our quick research, Google Support can help, but we're on Basic support plan and cannot open a support ticket. Please advise how to contact support, thanks in advance! 

[BartPudlo]

Hey @PavelEmdin99 - for any higher level of support than basic, it would be possible to create a ticket for a GCP support team where they could be able to proceed with disk shrink operation. 

However in your case, that might not be possible but do not worry as there are other possible workarounds in this case. 

In a nutshell, what you need to do is to create a new instance with desired lower disk size and move all the databases from that instance to the new one with smaller size. 

To do it, you can either use DMS - Database Migration Service where you can create a migration job from source instance to desired instance. Hope that this docs will help - https://cloud.google.com/sql/docs/mysql/migrate-data-to-cloud-sql-instance 

Another possible solution is using external replicas - so what you need to do is replicate new instance - https://cloud.google.com/sql/docs/mysql/replication/configure-external-replica follow this docs for reference so the new instance will be a an external replica of the existing (source) instance. Then promote this replica to the primary one and make is as a new active instance. 

Hope this workarounds going to help. If not, let me know!

Thanks 

[PavelEmdin99]

Thanks for you reply. We'll consider upgrading our support plan.  

[BartPudlo]

Sure, feel free to let me know if you need any assistance 

[PavelEmdin99]

So we bought a Standard support plan and my user has Tech Support Editor role. When opening a case, getting "You don't have permission to file tech-related support cases for organizations/195984130052". Please advise? 

[BartPudlo]

Hey @PavelEmdin99 

In this situation you don't have adequate permission to create a support case. 

First I would recommend checking this page https://support.google.com/googlecloud/answer/1041916?sjid=11430290480829030371-EU#file_support_case... and check section Grant a user access.

In a nutshell you need to contact your organization admin who can give you adequate permissions to create a support case (a.k.a. add you as a new user who would be able to interact with Google Support Team). 

Please let me know if that is going to help. 

Thank you!

[PavelEmdin99]

I am an organization admin and I have all the roles which described in this article. 

[BartPudlo]

Please attach a screenshot for that error message. 

[PavelEmdin99]

Please find attached error message and my roles. 

"You don't have permission to file tech-related support cases for organizations/195984130052."

"

[BartPudlo]

Also, please make sure that you got this role - roles/cloudsupport.techSupportEditor following this docs - https://cloud.google.com/support/docs/customer-care-procedures#before_you_begin

[BartPudlo]

Hey Pavel, 

are you sure you got Tech Support Editor and Viewer role at the organization level? Not only on the project level? The error message is refering to the organization level permission. 

https://cloud.google.com/support/docs/access-control#tech_support_editor

based on that docs please make sure that org level you got this role. "You can grant this role at the organization, folder, and project levels. For example, if you grant the Tech Support Editor role to a Google group on a specific project, all members of the group can manage support cases for that project."

[PavelEmdin99]

Yes, I have following permissions for organization Rocifinance (id: rocifinance).  

[PavelEmdin99]

Yes, you were right, I had permissions in one organization, but support package was bought for another. Now its sorted. Thanks for your help. 

[BartPudlo]

No worries! Happy to help! Happy computing!