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

xtrabackup switches for backup

johntestjohntest ContributorInactive User Role Beginner
Hi all,
I am trying to make the backups as fast as possible.
Currently I am using the following switches

innobackupex --no-lock --parallel=8 --rsync /backupdir

Using --no-lock as we were seeing lots of flush table read locks.
What can be the highest value for --parallel switch? I would this is based on number of cores but I've gone upto like 200 and it still works.

Also what else can I use here to make the backup even faster?



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.