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!