this post was submitted on 27 Feb 2025
31 points (97.0% liked)

Selfhosted

43307 readers
295 users here now

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!

founded 2 years ago
MODERATORS
 

I'm in the process of setting up backups for my home server, and I feel like I'm swimming upstream. It makes me think I'm just taking the wrong approach.

I'm on a shoestring budget at the moment, so I won't really be able to implement a 3-2-1 strategy just yet. I figure the most bang for my buck right now is to set up off-site backups to a cloud provider. I first decided to do a full-system backup in the hopes I could just restore it and immediately be up and running again. I've seen a lot of comments saying this is the wrong approach, although I haven't seen anyone outline exactly why.

I then decided I would instead cherry-pick my backup locations instead. Then I started reading about backing up databases, and it seems you can't just back up the data directory (or file in the case of SQLite) and call it good. You need to dump them first and backup the dumps.

So, now I'm configuring a docker-db-backup container to back each one of them up, finding database containers and SQLite databases and configuring a backup job for each one. Then, I hope to drop all of those dumps into a single location and back that up to the cloud. This means that, if I need to rebuild, I'll have to restore the containers' volumes, restore the backups, bring up new containers, and then restore each container's backup into the new database. It's pretty far from my initial hope of being able to restore all the files and start using the newly restored system.

Am I going down the wrong path here, or is this just the best way to do it?

you are viewing a single comment's thread
view the rest of the comments
[–] marcos@lemmy.world 2 points 6 days ago (1 children)

I figure the most bang for my buck right now is to set up off-site backups to a cloud provider.

If you don't have the budget for on-premises backup, you almost certainly can't afford to restore the cloud backup if anything goes wrong.

Then I started reading about backing up databases

Go read the instructions for your database in particular. They are completely different from each other. Ignore generic instructions.

now I’m configuring a docker-db-backup container

What is perfectly fine. But I'd first look how this interferes with the budget you talked about earlier and if it wouldn't be better to keep things simpler and put the money on data replication.

Either way, if your budget is low, I'd focus a lot on making sure you have the data when you need to restore, and less on streamlining the restore procedure. (That seems to be the direction you are going, so yeah, I'd say it's good.) Just make sure to test the restore procedure once in a while.

[–] RadDevon@lemmy.zip 2 points 5 days ago (1 children)

If you don’t have the budget for on-premises backup, you almost certainly can’t afford to restore the cloud backup if anything goes wrong.

I believe egress is free on Backblaze B2.

Just make sure to test the restore procedure once in a while.

Good call on this. Curious if you have a procedure for actually doing this. I could just wipe out my system and rebuild it from the backup, but then I'm in trouble if it fails. What does a proper test of a backup actually look like?

[–] marcos@lemmy.world 1 points 4 days ago

You test your backup by recreating your system, either in a local environment or in some cheap simulated one.

It's even better if you write a manual with the steps you needed. And try to follow (and update it) when you do it again.