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

Percona xtrabackup and pigz

JonhaJonha EntrantInactive User Role Beginner
Hello!

I want to using xtrabackup with pigz in order to speed up backups. I am using these commands:

Backup:

innobackupex --user=dbUser --password=dbPass --no-timestamp --stream=tar /backups | pigz -f >/backups/backup.tar.gz

Restore:

tar --use-compress-program=pigz -xif /restore/backup.tar.gz -C /restore/backup/
innobackupex --apply-log --use-memory=4G /restore/backup/
innobackupex --copy-back /restore/backup/

I think these commands are correct, but I would like to confirm it is a proper way to backup and restore using xtrabackup and pigz

I have MyISAM tables, MySQL Server version: 5.5.46-0ubuntu0.14.04.2-log (Ubuntu), innodb_version, 5.5.46, protocol_version 10

Thank you!
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.