So with xtrabackup you can:
xtrabackup --backup --compress --compress-threads=N --target-dir=/path/to/backup
why not:
xtrabackup --prepare --compress --compress-threads=N --target-dir=…
I haven’t found an easy way to use xtrabackup’s built-in compression after preparing a backup, if I missed something let me know. What I’m looking for is an easy way to have the host that’s providing the backup also prepare and then compress the full backup into an xbstream archive. Then when we go to restore, its just downloading the archive, xbstream --extract … and xtrabackup --decompress, and xtrabackup --copy-back …
I would suggest opening a Jira ticket under the PXB project (jira.percona.com) since this may or may not be considered as a feature request by the dev team. However, a workaround would be to prepare the backup and store everything in a tar.gz file.
That’s fair, basically a feature request. I created the issue, https://jira.percona.com/browse/PXB-2174