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.
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.