Now that there are so many options like
AWS
GCP
Azure
Digital Ocean
Heroku
Render
Firebase
Supabase
etc..
I was wondering does anyone these days Self-host databases on their infra?
Ask HN: Do you self-host your database?
1–10 of 236 posts
Re: Ask HN: Do you self-host your database?
#2I used to deploy apps using Google AppEngine and DataStore. For most projects, now just use AWS EC2 with EBS and self-managed Postgres or SQLite.
In my experience, it is rare to have 100+ TPS applications. As for FAANG scale infra - YANGNI!
Re: Ask HN: Do you self-host your database?
#3I'm hosting own MySQL, Mongo and Elastic clusters. At the beginning it takes more time to setup than cloud providers solutions and require more knowledge and tooling to do some ops(upgrades, backups etc). But you know which version of db you are running and how it is configured. Additionally cloud providers own solutions are binding with one of them.
Re: Ask HN: Do you self-host your database?
#4We self-host a postgres cluster in k8s (AKS).
The main reason being that the Azure postgres offering was not fit for (our) purpose.
We did start with the Azure offering, and our default is generally to use the cloud offering.
Re: Ask HN: Do you self-host your database?
#5Self-hosting MariaDB with multi-master replication. Works pretty well for my cases. Have a friend that was surprised by the AWS pricing changes on Aurora (they charge per query now instead of bandwidth/usage?)
Re: Ask HN: Do you self-host your database?
#6Self hosting PSQL via Docker container + Ansible.
Also hosting MongoDB, Elastic Search, Redis instances (for session & caching, separate instances).
Might consider researching using pg_bouncer later (but really not needed right now).
Pricing and support for vendor solutions are too bad for small scale app.
Re: Ask HN: Do you self-host your database?
#7I used to deploy apps using Google AppEngine and DataStore. For most projects, now just use AWS EC2 with EBS and self-managed Postgres or SQLite. In my experience, it is rare to have 100+ TPS applications. As for FAANG scale infra - YANGNI!
Interesting. Haven't heard many using DataStore.
How are you managing a. monitoring b. backups for self-managed?
Re: Ask HN: Do you self-host your database?
#8I'm hosting own MySQL, Mongo and Elastic clusters. At the beginning it takes more time to setup than cloud providers solutions and require more knowledge and tooling to do some ops(upgrades, backups etc). But you know which version of db you are running and how it is configured. Additionally cloud providers own solutions are binding with one of them.
Agree. It's a trade-off. If one knows how to do a bit of ops then it's feasible to self-host.
what's the scale of the application(s) that uses these data stores? How do you monitor these clusters?
Re: Ask HN: Do you self-host your database?
#9Self-hosting MariaDB with multi-master replication. Works pretty well for my cases. Have a friend that was surprised by the AWS pricing changes on Aurora (they charge per query now instead of bandwidth/usage?)
multi-master with conflict resolution is non-trivial.
Do you have automated failover set up?
Also, didn't know about Aurora's per query pricing. That is crazy.
Re: Ask HN: Do you self-host your database?
#10We have a few independent systems. Each runs on a two core VM with room to spare, so why not run the db server there too? It literally costs nothing.