Percona innobackupex Xtrabackup

howto.sh

# backup
innobackupex --stream=xbstream --parallel=4 --compress --compress-threads=2 /var/lib/mysql > /root/backup/backup.xbstream

# restore 
xbstream -x < /root/backup/backup.xbstream
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
yum install qpress
for i in $(find -name "*.qp"); do qpress -vd $i $(dirname ${i}) && rm -f $i; done
innobackupex --apply-log ./
service mysql stop
rm -Rf /var/lib/mysql/*
innobackupex --copy-back ./
chown -Rf mysql.mysql /var/lib/mysql
service mysql start