How do you handle backups on self managed servers?
 

Hi all

Do you guys upload it to another server via a cron script or do you download it locally?

Depends on the project/content

Code:
I always have one or more git repos for my code

SQL:
Standard shell script with weekly/daily/hourly cron triggering and upload to Google Drive.

Static:
Depending on the size I use to backup all the static content by zipping small files and direct downloading big ones, all done by shell scripting. Again if the size is reasonable I use online backup space, otherwise I backup on my local Synology NAS and I mirror it on BackBlaze B2.

Despite all of this there are projects I simply don't back-up since they aren't worth the effort.

Depends really on what you are backing up, how much data and how often it changes.

On our dev server what I do is every day create Monday.tar.gz, Tuesday.tar.gz, etc and upload it to an s3 storage overwriting the previous day so I have a 7 day rolling backup.

On a client's cam site where there's lots of financial transactions we do a dump every 3 hours and upload similarly with a 7 day rolling backup.

If I was running a paysite i'd backup the videos/thumbs incrimentally separately from the code and db.

In some cases it's cheaper to get a cheap machine from OVH and backup to that plus then you always have a "spare server" in case shit hits the fan and you need to get something back up quickly.

i use runcloud.io with my servers, they have backup integrated into the platform.

Do you have a control panel? If so 90% of them have a backup utility built into them.
What I do is have it backup to a local copy example /backups then I will rsync that to another server.

If you don't have a control panel, then something as simple as a several cron's one for a mysql dump ( or dumps ), one to tar up a directory, then to copy that tar to another folder, then a third one to rsync it offsite.

Just my 2 cents.
Thanks,
Anthony

I'm impressed ! :thumbsup:thumbsup:thumbsup

Wish I could go every three hours... :2 cents:

Create 1 backup to the cloud, and another one to on premises. Pm me and I will show you how.