53

What's your approach to databases?

posted
by
Avatar
AggressivelyPassive@feddit.de
in
Avatar
selfhosted@lemmy.world
38 comments
hidereport

I’m currently struggling with upgrading some Postgres DBs on my home-k3s and I’m seriously considering throwing it all away since it’s such a hassle.

So, how do you handle DBs? K8s? Just a regular daemon?

Sort:
HotTopControversialNewOld
Avatar
z3bra@lemmy.sdf.org
5 points

I have a single database server because I can’t afford two servers with high storage. The servers that need access to it connect over wireguard VPN. This is slow as f**k don’t do that.

permalink
report
reply
Avatar
Oliver Lowe@lemmy.sdf.org
4 points

I avoid software which requires a relational database altogether. For me that’s part of the fun of self hosting: what’s the simplest possible system I can get away with at my tiny scale?

permalink
report
reply
Avatar
AnUnusualRelic@lemmy.world
3 points

Cautiously.

permalink
report
reply
Avatar
I eat words@group.lt
2 points

using mostly operator from percona for kubernetes, sometimes just a simple deployment. Running postgresql for Lemmy from docker-compose as a container.

permalink
report
reply
Avatar
RogerSik@lemmy.sikorski.cloud
2 points

Own vm as regular daemon + acme.sh for tls.

Makes K3s more fun if db’s are outside and files (when possible) are on S3 (Minio Docker on Synology).

For the rest than pvcs with longhorn as storage driver.

permalink
report
reply

Selfhosted

!selfhosted@lemmy.world

Create post

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don’t control.

Rules:

  1. Be civil: we’re here to support and learn from one another. Insults won’t be tolerated. Flame wars are frowned upon.

  2. No spam posting.

  3. Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it’s not obvious why your post topic revolves around selfhosting, please include details to make it clear.

  4. Don’t duplicate the full text of your blog or github here. Just post the link for folks to click.

  5. Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).

  6. No trolling.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

Community stats

  • 4.8K

    Monthly active users

  • 3.7K

    Posts

  • 81K

    Comments

Community moderators