5
submitted 6 days ago by lemuria@lemmy.ml to c/selfhost@lemmy.ml

I run a Clickhouse database. My usecase is 99% writes and 1% reads - I rarely query the database. Currently, the tables (excluding system logs) use 6GB of the 80GB on my Ionos VPS, with the VPS having 50GB free space total.

In the far future, when that 50GB starts to run out, are there any cheap storage services out there that support a filesystem or a database? Due to querying the data so rarely, read speed isn't that big a deal, and if the storage is on HDD, so be it.

top 1 comments
sorted by: hot top controversial new old
[-] ch8zer@lemmy.ca 3 points 5 days ago

You could try something S3 based, and do backups by date?

For example, export a subset of the DB and name it accordingly (ie. 2025-04-to-2025-01.tar).

If you do that there are a lot of pretty cheap S3 providers (like Wasabi).

S3 interfaces nicely with RCLONE so you can move providers etc and pull it really quickly.

As an aside, when I looked into something like this the thing that made me hesitate was the time and cost for retrieval from cold storage (like amazon glacier) outweighed the savings.

this post was submitted on 01 Apr 2025
5 points (85.7% liked)

Self Hosted - Self-hosting your services.

12522 readers
20 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

Important

Beginning of January 1st 2024 this rule WILL be enforced. Posts that are not tagged will be warned and if not fixed within 24h then removed!

Cross-posting

If you see a rule-breaker please DM the mods!

founded 4 years ago
MODERATORS