Hacker News Reader

Hacker News

Comment by laixer | Hacker News Reader

Full thread

laixer

Cloud SQL for Postgres is launching today and will be available for all users early next week.

Source: Work on Cloud SQL.

View on HN

Any public timeline on HA feature availability, or way to be an early adopter?

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

Is it wise to use Cloud SQL + GKE? Some say it is not wise to use Docker for DB

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.

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."

I've been having rather significant latency going through the proxy (MySQL Cloud SQL) - has anyone else experienced similar?

> 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.

Half surprised plv8 isn't an in the box extension.

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...

I dont see it enabled on my account - I still only see mysql. How does one get it ?

It will be available for all users early next week.

I guess that would explain why I cannot add a PostgreSQL instance today...

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.

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?

Doesn't look like it.

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

Awesome! This is something I was really hoping for.

finally.

Reply on news.ycombinator.com