Re:Next generation of Google Cloud SQL
by coleca on Friday December 11, 2015 @09:48AM
(#10717340)
It's also a shame you can't use their own firewall rules with CloudSQL, or even specify instance tags to allow traffic inbound to CloudSQL. You have to specify IP ranges (CIDR) for each of your hosts. Makes it near impossible to allow an auto-scaling group to access CloudSQL since you have no control over the public IP that will be assigned to a new host being spun up in the ASG.
[ Parent
| on HN ]
It seems they approached the problem with a new solution: https://cloud.google.com/sql/docs/sql-proxy
,,The Cloud SQL Proxy provides secure access to your Cloud SQL Second Generation instances. ... It is especially useful when connecting from clients with dynamic IP address, such as Managed VM and Google Container Engine applications."
Re:Next generation of Google Cloud SQL
by simonmorley on Friday December 11, 2015 @11:23AM
(#10717962)
The proxy solution looks OK, shame it wasn't mentioned in the blog unless I'm blind.
Lack of private IPs has been the single reason why we've not moved our current dbs over. I'm sure it's hard but you're Google after all o_0
Pretty much the same situation for us, too.
I was really excited about the possibility of using Cloud SQL. Unfortunately, the lack of private IP whitelisting forces you to make some tradeoffs that don't make sense from the security perspective.