Deleted Private Service Access range for an existing Cloud SQL instance

Google Cloud Compute Infrastructure
1

Hello,

I am currently running a Cloud SQL (MySQL) instance that was created using VPC peering.

When attempting to create a new SQL instance, I noticed that the peering range associated with the SQL instance has been deleted.

However, while attempting to create a new SQL instance, I noticed that the allocated IP range associated with the existing SQL instance is deleted. There is nothing in the “vpc > private service access > allocated IP ranges for services”.

2
2549×579 39.4 KB

The console suggests that updating the connection will not affect existing instances (as shown in the attached screenshot), but I need to be absolutely certain that this operation will not disrupt my production database.

I found discussions on Stack Overflow[1] suggesting that the following command [2] resolves this issue. Before proceeding, I need to confirm the following points regarding the impact on my running instance:

  1. Data Integrity: Is there any risk of data loss or downtime during this update?

  2. IP Persistence: Will the Private IP address of the existing Cloud SQL instance change?

  3. Connectivity: Will the existing database IP address remain valid within the re-established peering range, ensuring no internal access/connectivity issues?

If there are any other precautions or “gotchas” I should be aware of before running this command, please let me know.

[1] https://stackoverflow.com/questions/55135559/unable-to-recreate-private-service-access-on-gcp

[2] gcloud services vpc-peerings update --service=servicenetworking.googleapis.com --ranges=[private_connection_range_name] --network=[vpc_network_name] --project=[project_name] --force

2

I tried that command,but unfortunately, it failed with an error stating that the allocated IP range could not be found. :joy:

ERROR: (gcloud.services.vpc-peerings.update) The operation “operations/$OPERATION_NUMBER” resulted in a failure "Allocated IP range ‘$ALLOCATED_IP_RANGE’ not found in network.

I am confused because I verified the allocated IP range name using the command [3] below, and it definitely exists in the list. I’m stuck at this point..

[3] gcloud services vpc-peerings list --network=$VPC_NAME