G-Cloud SQL Instance type change

[Arun Prasad]

Hi Team,

I need to change the Instance type of my Cloud SQL Instance type, in order to do this i need to know if stopping the Instance change the Public IP ?

[Kurt Josephson]

The public IP will stay the same when changing instance types (although your instance will have ~2 to 10 minutes of downtime while it switches machine types (I usually have experienced about 5 minutes, but have had it last up to 10 minutes).

-Kurt

On Thu, Feb 7, 2019 at 10:40 PM Arun Prasad <arunpr...@gmail.com> wrote:

Hi Team,

I need to change the Instance type of my Cloud SQL Instance type, in order to do this i need to know if stopping the Instance change the Public IP ?

--
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/b5bc8927-6024-4851-8d3e-e36d68dd82df%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Arun Prasad]

Hey Kurt,

Thanks for the reply. But my setup is like i do have a failover replica is there, so while i am changing the instance type what’s the possibilities of changing IP?

I read like, the IP of primary Instance will automatically allow to the Failover Instance. Correct me if i am wrong. 

In that case is it okay to Stop the primary for 5-10 minuets?

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAN-WJY8p649ihKa2puec6sOQY0tX8ridh2w8beXF%2B1jDpCicAw%40mail.gmail.com.

[Kurt Josephson]

Google wants to make these changes as seamless as possible so that your application (or whatever you have accessing the db) is always connecting to the same IP.  This means that if you make changes due to scaling (changing instance type) or a failover event triggers due to a region-wide failure, your sql instance will always have the same public ip.

The alternative would be a major hassle - so luckily they have you covered :)

-Kurt

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAOjk8QYDH276TcaOWvWFsy2ZcZGQV-NyOZbOZkeT97Lsffng%3Dw%40mail.gmail.com.

[Arun Prasad]

Hey Kurt,

Thanks for that wonderful reply. I scheduled it for today and the only concern i had is about the IP address. Thanks for your detailed explanation.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAN-WJY-cXL%3DcWU1zOK3G%3DyiaW0i0RhXMGnMHisCW1_vzK9Aa1Q%40mail.gmail.com.