I moved to San Francisco a couple of weeks ago and decided to share my experience through some tips.
I was lucky enough to have lots of people helping me out and giving me nice tips but you always get second thoughts about what they tell you and end up googling those exact things, seeking any sort of confirmation.
More
Some time ago I was researching open source backup tools and the available solutions were narrowed down to rsnapshot and rdiff-backup. I did kind of a benchmarking between both solutions. I was (and still am) interested mainly in the performance aspect of the backup tool, which of the two was more efficient. I did some tests and the goal of this post is to share the result.
I wont be getting into the differences between them. There are lots of great articles online that already do that and also a great book by O’Reilly called “Backup and Reovery” that also convers both these solutions.
The idea
Start with a 5Gb MySQL database that would grow between backups. Each growth would add random data to tables and new tables (new files). Rsnapshot would do new hourlys and rdiff-backup would do incremental backups once the first one was made. All backups would be run manually so that no simultaneous actions would happen.
