Re:Cloud SQL for PostgreSQL now generally available
by tinix on Wednesday April 18, 2018 @07:06PM
(#16872041)
> they have some ridiculous technology that maintains network connections and re-routes them when everything switches to the new VM
indeed, this is the primary reason i wish to switch. i have no problem maintaining our own stuff, we do that anyway. :) thanks for the details.
Re:Cloud SQL for PostgreSQL now generally available
by jsolson on Thursday April 19, 2018 @10:54AM
(#16876401)
If you (or the parent) are interested in some details about that ridiculous technology, there was a paper in NSDI this year: https://www.usenix.org/system/files/conference/nsdi18/nsdi18...
(disclaimer: I'm one of the many authors on the paper, although for building parts of the underlying tech, not writing the prose)
You can run PostgreSQL on a VM just fine. You just have to manage itself. Cloud SQL comes with some upsides (zero management, spectacular HA failover capabilities) and some downsides (lack of extensions, lives on a separate network, no control over maintenance window); you have to decide what you're willing to live with.
You can set the upgrade window, but it can't be predicted. What you can control is the order — e.g. set your staging instance to "early" and production instance to "late", then hopefully staging should be upgraded first and you'll know ahead of the production upgrade if any issues arose.
[1] https://cloud.google.com/compute/docs/instances/live-migrati...