Ask HN: Best Centralized Backup Solution

#1

Post by bkgh » Sun, Dec 16, 2018, 12:41 PM UTC

What is best free software for managing and scheduling backup procedure of folders/databases in many clients? I want a centralized system that have fine-grained schedule and can show backup status of folders and databases in different clients. It's better to have plugins for supporting backup using different kinds of tools like PostgreSQL(pg_dump), MySQL, Redis, SSH ,... . Backups can be stored on different places like S3, Dropbox and local folders.

Re: Ask HN: Best Centralized Backup Solution

#2

Post by InGodsName » Sun, Dec 16, 2018, 1:01 PM UTC

Using RDS seems like a best option.

Many startups use it, and i think backup is also easy.

Re: Ask HN: Best Centralized Backup Solution

#3

Post by rorykoehler » Sun, Dec 16, 2018, 1:06 PM UTC

Unison is good for syncing between 2 locations. Personally I would treat DB's and other files differently.

Re: Ask HN: Best Centralized Backup Solution

#4

Post by bagsvaerd70 » Sun, Dec 16, 2018, 1:09 PM UTC

I like to rsync into a BTRFS volume, and then take a snapshot.

It's simple, fine-grained (you can use .rsyncignore files like .gitignore files) and versioned.

Re: Ask HN: Best Centralized Backup Solution

#5

Post by m_b » Sun, Dec 16, 2018, 1:19 PM UTC

BackupPC is the best one: https://backuppc.github.io/backuppc/

You get every professional features out of the box (full/inc backups, deduplication, compression...) & everything is automated.

Re: Ask HN: Best Centralized Backup Solution

#6

Post by based2 » Sun, Dec 16, 2018, 1:19 PM UTC

https://www.reddit.com/r/backup

Re: Ask HN: Best Centralized Backup Solution

#7

Post by [deleted] » Sun, Dec 16, 2018, 1:27 PM UTC

[deleted]

Re: Ask HN: Best Centralized Backup Solution

#8

Post by zmix » Sun, Dec 16, 2018, 1:34 PM UTC

InGodsName wrote: post #2

Using RDS seems like a best option. Many startups use it, and i think backup is also easy.

He didn't say, he's using AWS. Or did you mean something different?

Re: Ask HN: Best Centralized Backup Solution

#9

Post by zmix » Sun, Dec 16, 2018, 1:40 PM UTC

burp (https://burp.grke.org/) comes to mind, as well. Windows and UNIX-like only, no macOS.

Re: Ask HN: Best Centralized Backup Solution

#10

Post by reacharavindh » Sun, Dec 16, 2018, 1:41 PM UTC

I think you're looking more for the "scheduling, managing pull from different clients" than the ability to backup to S3, Dropbox, local folder etc.

There are plenty of software projects to choose from for the latter. Borgbackup, Restic, Plain old NFSv3 and rsync, Tarsnap, Backblaze B2 etc.

I simply use a combination of Cron, rsync and Ansible to make backups to our central NAS, and that central NAS is mirrored to our off site NAS (with extensive snapshots and tape backups).

I had to use Netbackup for the Tape system which does everything you listed - managing and scheduling backup procedure in "clients" and does fine-grained schedule, show backup status etc. But, I HATE that thing with all my gut. It is one complicated pile of crap that I have to fight all the time to make it write to the damn tapes. Nothing like plain old simple Unix tools.