How do you handle backups on self managed servers?

[mrmister]

Hi all

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

[SevY]

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.

[k0nr4d]

Originally Posted by mrmister

Hi all

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

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.