How Managed database standby node works if datacenter is down?

Hello HenrykZaborowski!

DigitalOcean’s Managed Databases do offer high availability features, but standby nodes by default are usually within the same data center to minimize latency. If the primary data center goes down, the standby node takes over only within that same data center. With that said, a data center going down is highly unlikely, thanks to the robust infrastructure and multiple layers of redundancy that DigitalOcean has in place.

DigitalOcean data centers rarely experience full outages, as they are designed with significant redundancy and operational safeguards. I don’t recall any such events in the past few years based on the status page here:

https://status.digitalocean.com/

One option here to for your disaster recovery plan is, you could set up a read replica in a different DigitalOcean data center. While it wouldn’t be an automatic failover, in case of a primary data center outage, you could promote this read replica to become the primary node:

https://docs.digitalocean.com/products/databases/postgresql/how-to/add-read-only-nodes/#promote-a-read-only-node-to-become-a-primary-node

In addition to that, the best thing to do to get your voice heard regarding this would be to head over to our Product Ideas board and post a new idea, including as much information as possible for what you’d like to see implemented.

https://ideas.digitalocean.com/

Hope that helps!

- Bobby.