News for hackers. Stuff that matters.
Re:Google Cloud SQL for Postgres by laixer on Thursday March 09, 2017 @01:12PM (#13831415)
Cloud SQL for Postgres is launching today and will be available for all users early next week.

Source: Work on Cloud SQL.

Re:Google Cloud SQL for Postgres by numbsafari on Thursday March 09, 2017 @01:27PM (#13831616)
Any public timeline on HA feature availability, or way to be an early adopter?
Re:Google Cloud SQL for Postgres by samaysharma on Thursday March 09, 2017 @02:00PM (#13831972)
The replication and high availability related documentation is here:-

https://cloud.google.com/sql/docs/postgres/high-availability

https://cloud.google.com/sql/docs/postgres/replication/

Any timelines on high availability support? This would be pretty helpful

Re:Google Cloud SQL for Postgres by 0x27081990 on Thursday March 09, 2017 @02:49PM (#13832727)
Is it wise to use Cloud SQL + GKE? Some say it is not wise to use Docker for DB
Re:Google Cloud SQL for Postgres by theptip on Thursday March 09, 2017 @04:21PM (#13833796)
Yes, it is wise to do that. If you don't want the overhead of running your own SQL instance, you definitely don't want the overhead of running it on kubernetes; it's quite tricky (but the addition of StatefulSets in 1.5 has made it easier).

If you're running a CloudSQL instance, you can use a sidecar container to manage proxying the connection to the database: https://github.com/GoogleCloudPlatform/cloudsql-proxy

"The Cloud SQL Proxy allows a user with the appropriate permissions to connect to a Second Generation Cloud SQL database without having to deal with IP whitelisting or SSL certificates manually."

Re:Google Cloud SQL for Postgres by nstj on Friday March 10, 2017 @12:41AM (#13836655)
I've been having rather significant latency going through the proxy (MySQL Cloud SQL) - has anyone else experienced similar?
Re:Google Cloud SQL for Postgres by daenney on Thursday March 09, 2017 @06:14PM (#13834747)
> Some say it is not wise to use Docker for DB

I think what most people mean when they say that is "don't put the DB in Docker", so don't use Docker to host Postgres. Just because your app is hosted by Docker doesn't make it more or less wise to connect to a database. It just depends on if you need a database or not.

Re:Google Cloud SQL for Postgres by oomkiller on Thursday March 09, 2017 @02:54PM (#13832817)
This is exactly what I plan to do. Not really because of any specific issue with Docker, it's just that databases have very different lifecycles than your typical container.
Re:Google Cloud SQL for Postgres by tracker1 on Thursday March 09, 2017 @03:41PM (#13833368)
Half surprised plv8 isn't an in the box extension.
Re:Google Cloud SQL for Postgres by areski on Friday March 10, 2017 @11:47AM (#13839903)
It could be a very useful one to have. To request support for an extension, start a thread on the Cloud SQL Discussion group. https://groups.google.com/forum/#!forum/google-cloud-sql-dis...
Re:Google Cloud SQL for Postgres by sandGorgon on Thursday March 09, 2017 @01:24PM (#13831577)
I dont see it enabled on my account - I still only see mysql. How does one get it ?
Re:Google Cloud SQL for Postgres by laixer on Thursday March 09, 2017 @01:26PM (#13831600)
It will be available for all users early next week.
Re:Google Cloud SQL for Postgres by jjuel on Thursday March 09, 2017 @03:55PM (#13833511)
I guess that would explain why I cannot add a PostgreSQL instance today...
Re:Google Cloud SQL for Postgres by rankam on Thursday March 09, 2017 @04:58PM (#13834146)
Sorry for hijacking, but is there an issue with Cloud SQL right now? I keep getting authentication issues from the GCP dashboard even though I've logged in with 2FA multiple times and when I try to visit my Cloud SQL instances, it just says failed to load.
Re:Google Cloud SQL for Postgres by jjessejj on Thursday March 09, 2017 @02:57PM (#13832851)
is this cloud sql for postgres autoscale auto replicate fully managed hands off like app-engine and datastore or does this need to be managed manually?
Re:Google Cloud SQL for Postgres by elvinyung on Thursday March 09, 2017 @06:44PM (#13834968)
Doesn't look like it.

I suspect that they intend that use case to be fulfilled by Cloud Spanner: https://cloud.google.com/spanner/

Re:Google Cloud SQL for Postgres by masterleep on Thursday March 09, 2017 @01:17PM (#13831478)
Awesome! This is something I was really hoping for.
Re:Google Cloud SQL for Postgres by merb on Thursday March 09, 2017 @01:26PM (#13831590)
finally.