How to Efficiently Choose the Right Database for Your Applications

Re:How to Efficiently Choose the Right Database for Your App... by aaronharnly on Sunday February 28, 2021 @05:08AM (#26292178)

Postgres is our goto, but in particular we have been pretty satisfied lately with AWS so-called “serverless” Aurora Postgres, which allows utilization to scale down during quiet periods, which is very helpful in a lots-of-microservices context, which can otherwise have a pretty high cost floor from having many Postgres DBs that have to be sized to accommodate their peak load.

DynamoDB, which I was slow to come around on, is attractive for the same reason, although it only works if the use case fits, obviously.

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by eugenejen on Monday March 01, 2021 @12:50PM (#26305661)

Even you use DynamoDB, you still need to remember to have backupss. I have seen a recent mishap when devops by accident dropped the production tables and restoration requires high IOPs in order to restore it soon enough. The IOPs was not that high for usual use case. But when you wants to reduce MTTR, you need to increase the IOPs (which means $$$, too)

Eventually your dropping of the database is consistent. So back it up no matter what.

[ Parent | on HN ]