1.压缩备份
/opt/xtrabackup-8.0.35-34/bin/xtrabackup --defaults-file=/home/middle/mysql8/conf/my.cnf --user=root --password=mysql -P13306 --socket=/tmp/mysql.sock --compress --no-version-check --backup --target-dir=/opt/xtrabackup_file/mybak_`date "+%Y%m%d"`
解压
/opt/xtrabackup-8.0.35-34/bin/xtrabackup --decompress --parallel=5 --remove-original --target-dir=/opt/xtrabackup_file/mybak_20250908
2.流式备份
/opt/xtrabackup-8.0.35-34/bin/xtrabackup --defaults-file=/home/middle/mysql8/conf/my.cnf --user=root --password=mysql -P13306 --socket=/tmp/mysql.sock --stream=xbstream --no-version-check --backup --target-dir=/opt/xtrabackup_file > /opt/xtrabackup_file/mybackup.xbstream
解压流式备份
[root@xxx ~]# mkdir -p /opt/xtrabackup_file/mybackup
[root@xxx ~]# /opt/xtrabackup-8.0.35-34/bin/xbstream -x --parallel=10 -C /opt/xtrabackup_file/mybackup < /opt/xtrabackup_file/mybackup.xbstream