I have an instance group set up with Auto Scaling and Load Balancing. I'm also using Google Cloud SQL for the MySQL server.
Whenever instance group scales up and adds another instance, the instance gets a new IP address. The problem is that this instance no longer has access to the Google SQL instance (since the SQL instance requires authorized networks to be pre-configured). What can I do about this?
I'm currently accepting most IPs to my SQL server by adding the following IPs to the Authorized IPs in the SQL manager:
100.0.0.0/6
104.0.0.0/5
112.0.0.0/4