Percona XtraBackup moved to https://jira.percona.com/projects/PXB

compressed backups cannot be restored without an external utility (qpress)

Bug #1176240 reported by Ryan Lowe on 2013-05-03

This bug affects 5 people

	Status	Importance	Assigned to	Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB	Triaged	Medium	Unassigned	Percona XtraBackup moved to https://jira.percona.com/projects/PXB future-2.3-releases
2.0	Won't Fix	Medium	Unassigned
2.1	Triaged	Medium	Unassigned	Percona XtraBackup moved to https://jira.percona.com/projects/PXB future-2.1-releases
2.2	Triaged	Medium	Unassigned	Percona XtraBackup moved to https://jira.percona.com/projects/PXB future-2.2-releases
2.3	Triaged	Medium	Unassigned	Percona XtraBackup moved to https://jira.percona.com/projects/PXB future-2.3-releases

Bug Description

If I create a backup with --compress, there is no way for me to uncompress that backup without an (uncommon) external utility.

See http://www.percona.com/doc/percona-xtrabackup/howtos/recipes_ibkx_compressed.html

I would love to see some sort of built-in --uncompress option so I could do something like:

%> innobackupex --compress /data/backup

and then

%> innobackupex --uncompress --apply-log /data/backup/2012-06-01_11-24-04/

Revision history for this message

Alexey Kopytov (akopytov) wrote on 2013-05-06:

Yes, it's been discussed a number of times, but not filed anywhere. We are going to package qpress in Percona repositories (and make xtrabackup packages depend on it).

Note that we have the manual uncompress procedure documented at http://www.percona.com/doc/percona-xtrabackup/howtos/recipes_ibkx_compressed.html

Revision history for this message

Ryan Lowe (ryan-a-lowe) wrote on 2013-05-06:

If somebody were interested in sponsorship, how many hours of work are we estimating for this?

Revision history for this message

Ryan Lowe (ryan-a-lowe) wrote on 2014-08-14:

*bump*

Revision history for this message

Andreas Stieger (andreasstieger) wrote on 2014-09-30:

I do not see how this a bug for xtrabackup. Qpress can be trivially built, and I have added this to my preferred distribution as a standard package. An third-party package publisher should not be concerned with supplying every single item.

On that note, I found the compressio ratio (not the compression speed) of qpress to fall below what I require. I prefer streaming backups using xbstream and then using my own compression, or offline compression from a disk cache. Here, pixz is my current preference favouring very good compression ratios with the ability to use all CPUs in the system.

The is a good chance you are running to RHEL/CentOS. So as a courtesy for your friendly openSUSE packager your will qpress package (and pixz, for that matter) in the repositories below.
http://software.opensuse.org/download.html?project=home%3AAndreasStieger%3Abranches%3AArchiving&package=qpress
http://download.opensuse.org/repositories/home:/AndreasStieger:/branches:/Archiving/