Re:Neon – Serverless Postgres
by skrtskrt on Saturday May 28, 2022 @10:31AM
(#31540618)
No read replicas that can be promoted to master in an outage?
[ Parent
| on HN ]
Re:Neon – Serverless Postgres
by davidzweig on Saturday May 28, 2022 @05:16PM
(#31543937)
Ah, nop. If it goes down, we'll figure it out.. 24hrs outage wouldn't be the end of the world. Would have been nice to have a second (read replica) machine in East Asia, to reduce latency for users there, but didn't find a provider like Hetzner.. maybe could take a server in a suitcase and install it in a collocation center there. Bit of a hassle though.
I have a similar setup as OP, and I use ZFS snapshots to be able to quickly rebuild the whole machine on another host. Of course, it still requires manual intervention in an outage (it could be automated, theoretically), and I may lose up to 5 minutes of data due to my snapshot schedule.