But there has to be a better way to create automatic backups.
If the way you are doing it works, there isn't a better way.
So to me, the place to start is to make sure what you are doing is working (if you haven't).
I mean having one copy on another cloud provider isn't very deep.
As in only one cancelled credit card from failure (or maybe two).
Or two compromised credentials, at best.
Backing up either sucks or it isn't really backing up. It is not a good place to look for efficiency, because not backing up is always going to be easier than what you are doing.
I'm not so much looking for efficiency, but for simplicity.
This contraption of scripts that get called by cronjobs, that then access some account on DigitalOcean etc. just seems to complex to me.
If I want to check if everything works, I have to check several places.
My own documentation of this backup process is several pages long.
Considering how many people need to backup databases on linux, I was hoping there'd be a better, simpler practice.
If the way you are doing it works, there isn't a better way.
So to me, the place to start is to make sure what you are doing is working (if you haven't).
I mean having one copy on another cloud provider isn't very deep.
As in only one cancelled credit card from failure (or maybe two).
Or two compromised credentials, at best.
Backing up either sucks or it isn't really backing up. It is not a good place to look for efficiency, because not backing up is always going to be easier than what you are doing.
Good luck.