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?