XtraBackup fails

WillA_A_A · December 30, 2020, 4:21pm

Hello,

I’m using XtraBackup on CentOS-6.4 with MySQL-5.5.32 from www.mysql.de.

Sometimes my backup jobs crashing because the backup target is running out of space.

My backup space has 50GB and one backup job is using 6.8GB. I have no history, every job is overwriting the backup.

/usr/bin/innobackupex-1.5.1 --user=root --password=… --no-timestamp --databases=mydatabase --include=$quaterlyTables /var/backups/$myserver/quaterly/${quaterly}/
/usr/bin/innobackupex-1.5.1 --apply-log /var/backups/$myserver/quaterly/${quaterly}/

Software:
CentOS release 6.4 (Final)
Kernel \r on an \m
2.6.32-358.14.1.el6.x86_64
percona-xtrabackup-2.1.4-656.rhel6.x86_64
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Ireland Ltd 2009-2012. All Rights Reserved.

Regards - Willi

niljoshi · December 30, 2020, 4:30pm

Hi,

Can you provide some more information like full backup log of innobackupex, the output of “df -h” and “du -csh /var/backup” on that server? We also need to identify that while taking backup you are getting this error or while running --apply-log.

mariasam · December 30, 2020, 4:30pm

I found out these problems came when I created the backups with “–compact” option. The documentation are wrong about how to do restore, and theres an example ‘find’ which doesn’t find any compressed files…

chrisjacob · December 30, 2020, 4:31pm

I am using Cent OS 6.5 version as my server OS as it is the most XtraBackup in the system. Is there any compatibility issues with these two? Can I go ahead and install the software straight?

Chris- outlook 2007 download

mirfan · December 30, 2020, 4:31pm

Xtrabackup works absolutely fine on CentOS 6. For compact backups i would suggest to check this blogpost from niljoshi http://www.mysqlperformanceblog.com/2013/06/26/limited-disk-space-compact-backups-with-percona-xtrabackup-2-1/
Also, post the stuff which already asked by niljoshi to identify where the problem lies. Probably it’s failing on prepare stage because of secondary indexes size may be.