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

Does xtrabackup support compressed tables? (ROW_FORMAT=COMPRESSED)

Asked by Dave Juntgen

It appears that xtrabackup does not support the backing up of a compressed innodb table using.

innodb_strict_mode = 1
innodb_file_per_table = 1
innodb_file_format = barracuda

...

>> log scanned up to (930405791312)
[01] ./wc_miehr_wct138/audit_log_chart.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct138/logins_failed_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct138/logins_activity_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct138/logins_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct138/logins_used_tickets.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct57/audit_log_chart.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct57/logins_failed_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct57/logins_activity_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct57/logins_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct57/logins_used_tickets.ibd is compressed with page size = 8192 bytes
>> log scanned up to (930405791312)
[01] ./wc_miehr_wct43/audit_log_chart.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct43/logins_failed_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct43/logins_activity_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct43/logins_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct43/logins_used_tickets.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct102/audit_log_chart.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct102/logins_failed_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct102/logins_activity_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct102/logins_log.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct102/logins_used_tickets.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct51/audit_log_chart.ibd is compressed with page size = 8192 bytes
[01] ./wc_miehr_wct51/logins_failed_log.ibd is compressed with page size = 8192 bytes
innobackupex: Error: ibbackup child process has died at /usr/local/bin/innobackupex line 336.
Wed Jul 20 12:12:48 EDT 2011 Backup failed!

Any idea to what went wrong here?

Question information

Language:
English Edit question
Status:
Solved
For:
Percona XtraBackup moved to https://jira.percona.com/projects/PXB Edit question
Assignee:
Alexey Kopytov Edit question
Solved by:
Dave Juntgen
Solved:
Last query:
Last reply:
Revision history for this message
Alexey Kopytov (akopytov) said : 		#1

Hi Dave,

The xtrabackup binary does support compressed tables. From the log it looks like it just crashed silently, which may be either a bug in compression support, or a completely different issue.

Can you try to do a backup with just xtrabackup (i.e. without using innobackupex)?

Revision history for this message
Dave Juntgen (djuntgen) said : 		#2

I'm not sure whats going on. I was able to successfully run a backup last night... Marking as Solved unless I come up with some sort of compelling evidence of a bug.

Also - I believe tar4ibd doesn't support compression, so no streaming compressed tables? I believe Percona is working on a fix for that.

Revision history for this message
Alexey Kopytov (akopytov) said : 		#3

Dave,

Re. tar4ibd + compressed tables, fix for https://bugs.launchpad.net/percona-xtrabackup/+bug/665210 will be released in 1.6.3.