After 7 years on Raspberry Pis, I've finally moved my self-hosted services to Proxmox
Now that I'm hosting websites that people actually rely on, I decided I could no longer depend on Raspberry Pis for production workloads.
That's not a criticism of the Pis, they've been incredibly reliable for me. Over the last 7 years they've barely missed a beat, which I know is just good luck.
I've now moved to a Proxmox server with RAID1 SSDs for the OS because it makes backups, snapshots, and offsite disaster recovery much easier. Previously I was syncing databases to OneDrive using Duplicati, which worked fine, but I always felt that recovering from a complete hardware failure would be a bit of a hassle and could take longer than I'd like. However this single move only took about 5-6 hours.
That said, I'm still looking into proper database backup strategies. A lot of the websites use SQLite. One thing I really liked about my old setup was how easy it was to copy the data files to another machine, start the Docker containers, and be back up and running. There may be situations where I need to temporarily move services onto hardware that isn't/cannot run a full Proxmox hypervisor, so I'd like to keep that flexibility if possible, I still have not decided on this so any help would be much appreciated (I am going for free[no-subs], reliable, fast recovery).