@markus@hachyderm.io @gotosocial@thefedi.forum I've had to turn it off for now. It's continuing to eat disk space. I didn't know if I could just delete all those files or it would comprise the integrity of the mirror process. Very odd.
I did try their support channel but no response in a week. I'm at a loss. Need to try and find a new solution.
#litestream
Anyone using #litestream for an #sqlite DB
I have a 3GB database, and Litestream is replicating it to another server. However, it seems to be running out of control with disk space. On the original server (where the live DB is) is a generations folder under the hidden litestream folder. It is full of WAL files. Currently over 37,000 files consuming 118GB of disk space.
My config includes retention: 24h and retention-check-interval: 1h with a snapshot-interval: 4h. I understood it would delete anything older than 24 hours. Am I doing something wrong? These wal files go back to the day I started using litestream
#GoToSocial #gts @gotosocial@thefedi.forum
I am continuously amazed how far you can get with ancient tech stacks. :D My ARM-based VPS at Hetzner, with all my #GoLang web apps, using #SQLite with #Litestream for streaming replication, has had zero downtime for over a year now.
@chrisg If you had to rank them in order, which aspects are most/least important to your vision?
- storage engine
- replication protocol(s)
- backup / resilience mechanisms
- query / indexing modes
- primary means of access (web, SQL, ...)
- license
Do you see this falling somewhere on the #SQLite / #Litestream / #LiteFS spectrum, or are you envisioning a new greenfield project?
after wrapping some deployments of #sqlite apps with #litestream last weekend, it's a lot of fun to delete kubernetes pods and see that it resumes like nothing happened, despite the lack of external database or persistent volumes
i feel like #selfhosting problems would be much simpler if all apps just use #sqlite paired with #litestream, then consolidate management of storage with minio 
gonna try it out
https://fly.io/blog/all-in-on-sqlite-litestream/
Really interesting future for sqlite. Anyone with any notable experience to share? #sqlite #sqlite3 #flyio #litestream #databases #durftevragen
