Ask HN: What backup strategy do you use for your websites and databases?

https://news.ycombinator.com/item?id=2762730

by pankratiev • 15 years ago

15 9 15 years ago

news.ycombinator.com

I make local backups and then have a routine that downloads those backups. I tried one too many times relying on web hosts for backups...

adyus• 15 years ago

Hmm, given that the question was asked on HN, there could be a good business idea there... File and DB backups offered as SaaS.

sander• 15 years ago

There actually is a service that backups your website through FTP regularly, just trying to think of the name...

LaggedOut• 15 years ago

Backups, who needs them ;)

Zakuzaa• 15 years ago

I rsync my backups to bqbackup.

agj• 15 years ago

For backups, I use rdiff-backup across 60G+ of user data, nightly. rdiff-backup uses librsync to transfer files, but also handles incremental backups and seems to be fairly efficient at storing increments. Nightly, maybe 10%, maximum, of the user data changes and backups complete in less than 2 hours. Load is low enough I could run several times a day if I needed.

Databases should be properly dumped to a file before back up.

I've also tried BackupPC, which was a great project, but probably not the best fit for this case. I was running it in a virtualized container, and I ran into a lot of memory issues backing up large servers. This issue likely came down to memory -- not necessarily BackupPC itself -- but I dropped it because backups commonly took around 6-8h, if they didn't silently hang on me.

timdev• 15 years ago

rsnapshot with some scripts to prepare database dumps to grab ensure mysqldata is included. Works very well.

latch• 15 years ago

I actually check that I can restore from my backups once a week (it's the first thing I do when I wake up Saturday morning).

europa• 15 years ago

I use duplicity. http://duplicity.nongnu.org/

Ask HN: What backup strategy do you use for your websites and databases?

Related Stories