homelab

10471 readers

1 users here now

founded 6 years ago

MODERATORS

CMonster@lemmy.ml

One database container or many? (lemmy.world)

submitted 2 weeks ago by RustyNova@lemmy.world to c/homelab@lemmy.ml

6 comments fedilink hide all child comments

I'm self hosting a lot of small apps that require databases to function. So far, each stack has its own database, but I'm wondering if it would be better to centralise the data into one single database instance

All the apps are low traffic (it's just me), and security concerns are minimal (no sensitive data)

Does anyone have any advice on this?

you are viewing a single comment's thread
view the rest of the comments

[–] sorter_plainview@lemmy.today 1 points 1 week ago

Resource overhead when using multiple instances is negligible. But the benefit is if an app move to a nee major version of the db, then you can migrate easily. Also you don't have to worry about permissions, multi tenancy, roles, etc.

Only benefit of using a centralised db is easier back ups. But that is not enough for a centralised db IMO.