Not the answer you need?
Register and ask your own question!

Xtrabackup built-in compression after --prepare

jzzareskjzzaresk Current User Role Contributor
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 ...



Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    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.
  • jzzareskjzzaresk Current User Role Contributor
    That's fair, basically a feature request.  I created the issue, https://jira.percona.com/browse/PXB-2174
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.