CODEWITHSUNDEEP
google-cloud-platformgoogle-compute-engine
arecaps
arecaps

Reputation: 173

Assign static IP to GCP SQL instance

I need to assign a static IP to a SQL replica database instance, so that I can delete and recreate it with the same IP address. I dont see any way to do this. Can this be done for SQL, or only for Google Compute Engine instances?

Upvotes: 3

Views: 2192

Answers (2)

Aarik Mudgal
Aarik Mudgal

Reputation: 16

Correct, But you can assign static IP to a Compute Engine Instance and setup your SQL replica over that machine. And when you've given proper rights in the SQL Roles you'd be able to drop/create the database over the same machine with same IP.

Upvotes: 0

Federico Panunzio
Federico Panunzio

Reputation: 964

As of today it’s not possible to assign a static IP to a Cloud SQL instance as it is for GCE. When you create an instance, a random IP is assigned and when you delete the instance that IP is released. Also, the deleted instance name can’t be reused for up to a week according to the documentation

Upvotes: 4

Related Questions