June 18, 2013

Post: How would you compress your MySQL Backup

… compression tool ? The classical tool used for backup compression is gzip – it exists almost everywhere, it is stable and relatively fast… means if your goal is faster local network transfer default GZIP compression will not speed things up on the standard point… using dedicated server for backups. I should also note for mysqldump backup typically tools with better and slower compression make sense…

Comment: How would you compress your MySQL Backup

If you want the best possible compression ratio go with mysqldump + bzip. I can squeeze a 130gb database into about 6… 8 core server). I get almost 50% better compression of mysqldump files with bzip2smp and it runs twice as fast as gzip.

Comment: Compression for InnoDB backup

…-gigabyte database backup (mysqldump file), it can reduce the file to approximately 70% the size of a gzip‘ed in about the…

Comment: About This Blog

… then a lengthy mysqldump to a text file? This also is extremly large, and even compressed with tar && gzip -9 can’t…