On Nov 8, 2012, at 1:57 PM, David Hicks <dh...@i-hicks.org
> This looks like a very cool manager for XtraBackup. I'd love to put it into use. What I don't see in the documentation is any reference to the possibility of compressing the backup files. I currently do that with XtraBackup because our databases are so large that storing uncompressed backup sets would take far too much space. Is there such an option that I'm just not seeing? If not, would it be terribly difficult to add?
Currently XBM does not have support for compressed backups on disk. This was done as a somewhat lazy choice on my part during the initial build, because the company I was working for was using ZFS (filesystem) with compression enabled for storage. This made additional compression redundant, so I didn't spend my time on it.
Compression is somewhat difficult to enable with many of the features that XBM provides.
For example.. If you are using a backup strategy where you are collapsing your oldest delta onto the seed as you continue to roll forward your backups, you will be unable to apply the deltas if the seed is compressed.
This would require uncompressing the seed (full backup) for XtraBackup to be able to see the uncompressed files, and then merging the oldest deltas, then re-compressing. It is a lot of thrashing work to do :(
If however, you only make use of full backups each time, it would be fairly simple to implement compression.
So the answer is that it depends on the backup strategy that you plan to employ -- in some cases it would be easy (full backup only) and in others it would be a mix of infeasible and somewhat involved.
I have been kind of slack on any further development on XBM, but I wouldn't mind getting back to it to update it for some of the newer XtraBackup features and also consider improving it to be able to support compression better.
Any interest in helping develop? :)