Postmortem of database outage of January 31
I have to say - if they were using a managed relational database service, like Amazon&#x27;s RDS Postgres, this likely would have never happened.  RDS fully automates nightly database snapshots, and ships archive logs to S3 every 5 minutes, which gives you the ability to restore your database to any point in time within the last 35 days, down to the second.<p>Also, RDS gives you a synchronously replicated standby database, and automates failover, including updating the DNS CNAME that the clients connect to during a failover (so it is seamless to the clients, other than requiring a reconnect), and ensuring that you don&#x27;t lose a single transaction during a failover (the magic of synchronous replication over a low latency link between datacenters).<p>For a company like Gitlab, that is public about wanting to exit the cloud, I feel like they could have really benefited from a fully managed relational database service.  This entire tragic situation could have never happened if they were willing to acknowledge the obvious: managing relational databases is hard, and allowed someone with better operational automation, like AWS, to do it for them.