Currently, I have databases with 2.2TB of data. I am using Xtrabackup as follows:
innobackupex --rsync --user=xxx --password=xxx --no-timestamp --compress --compress-threads=4 $BACKUP_DIR/FULL
for bf in
find $BACKUP_DIR/FULL -iname "*\.qp"; do qpress -d $bf $(dirname $bf) ;echo “processing” $bf; rm $bf; done
innobackupex --apply-log --redo-only $BACKUP_DIR/FULL > $BACKUP_DIR/log_prepare.txt 2>&1
tar -czvf FULL.tar.gz FULL/
The total time for the backup process is 2.5 days.
The total time for restore in another server is 1 days (uncompress tar.gz file and copy back)
I’m not thinking of any way to backup and restore data in the shortest time.
Looking forward to receiving help from everyone.