Ajen

joined 2 years ago
[–] Ajen@sh.itjust.works 1 points 1 week ago* (last edited 1 week ago)

Besides RAM, what resources do you think you're saving? Not CPU cycles or IO ops, because you're processing the same amount of DB queries either way. Not power consumption, since that isn't affected by RAM utilization. Maybe disc space? But that's even cheaper than RAM.

Or more importantly: the extent to which you can self-host out of sheer luck and ignorance like you suggest is very limited. If you don't want to engage with a minimum amount of configuration, you might bump into security issues (a much broader and complex subject) long before any of the above has a material impact.

You're mischaracterizing what I said. My point is that running multiple DB processes on a server isn't going to have a significant impact on system load, if all other factor are kept constant.

[–] Ajen@sh.itjust.works 1 points 1 week ago (2 children)

You seem to be obsessed with optimising one resource at the expense of others. Time is a limited resource, and even if it only takes 5 minutes to configure all of your containers to share a single db backend (it will take longer than that even if you just have 2), you're only going to save a few MB of RAM. And since RAM costs roughly $2.5/GB (0.25 cents/MB) your time would have to be worth very little for this to be worthwhile.

On the other hand, if you're doing it to learn more about computers then it might be worthwhile. This is a community of hobbiests, after all...

[–] Ajen@sh.itjust.works 2 points 1 week ago

Neither, I'm trying to explain that you don't need to know the implementation details of the software running on your server to backup the entire thing.

[–] Ajen@sh.itjust.works 1 points 1 week ago (2 children)

Where are you getting that from? The fastest and easiest way to back up any server is a full filesystem backup, especially if you're using something like zfs or btrfs.

[–] Ajen@sh.itjust.works 1 points 1 week ago (4 children)

I'm saying this based on real world experience: after a certain point you start to see deminishing returns when optimizing a system, and you're better off focusing your efforts elsewhere. For most applications, customizing containerized services to share databases is far past that point.

[–] Ajen@sh.itjust.works 4 points 1 week ago (6 children)

Do you have the data to back that up? Have you measured how much of an impact on system load and power consumption having 2 separate DB processes has?

Roughly the same amount of work is being done by the CPU if you split your DBs between 2 servers or just use one. There might be a slight increase in memory usage, but that would only matter in a few niche applications and wouldn't affect environmental impact.

[–] Ajen@sh.itjust.works 22 points 1 week ago (9 children)

For most applications the overhead of running a second DB server is negligible.

[–] Ajen@sh.itjust.works 116 points 1 week ago (17 children)

I write software for a living, and have worked with all 3 database options in the past. I don't know what DB backend my nextcloud server is using, nor do I care.

[–] Ajen@sh.itjust.works 3 points 2 weeks ago

Everything on ollama can be run locally without much work. Assuming you have the GPU to support it...

https://ollama.com/

[–] Ajen@sh.itjust.works 3 points 3 weeks ago (1 children)

Heh, seems like you hit a nerve with that poster.

To answer your question - IMO it's still that bad, but I'm not sure what the right way to respond is, either.

[–] Ajen@sh.itjust.works 2 points 1 month ago (1 children)

Yes, but even living across the street from a hospital doesn't guarantee you will have access to medical care. Plenty of people who live in the city can't afford an ambulance or hospital stay.

[–] Ajen@sh.itjust.works 5 points 1 month ago (9 children)

A well, septic tank, and solar can replace water, sewer, and electrical utilities. ATVs, dirt bikes, and snowmobiles (depending on location) make roads unnecessary. What other infrastructure do you need?

view more: next ›