xtrabackup 8.0日常管理

 

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.xb

 

 

解压流式备份

 

[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.xb

 

 

3.流+压缩备份

备份

/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 --no-version-check --backup --compress --stream=xbstream --target-dir=/opt/xtrabackup_file>/opt/xtrabackup_file/mybackup.xbstream

 

解压要分2个步骤

流解压
mkdir -p /opt/xtrabackup_file/mybackup
/opt/xtrabackup-8.0.35-34/bin/xbstream -x --parallel=10 -C /opt/xtrabackup_file/mybackup < /opt/xtrabackup_file/mybackup.xbstream

常规解压
/opt/xtrabackup-8.0.35-34/bin/xtrabackup --decompress --parallel=5 --remove-original --target-dir=/opt/xtrabackup_file/mybackup

 

4.流式备份+gzip

/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 --no-version-check --compress-threads=4 --backup --stream=xbstream --parallel=4 | gzip > /opt/xtrabackup_file/mybak20250910.xb.gz

 

执行该命令后会在当前目录下创建一个xtrabackup_backupfiles目录,该目录是空的，我们也可以指定具体的目录，备份完成后该目录也是空的

/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 --no-version-check --compress-threads=4 --backup --stream=xbstream --parallel=4 --target-dir=/opt/xtrabackup_file | gzip > /opt/xtrabackup_file/mybak20250910.xb.gz

 

分步解压
[root@localhost xtrabackup_file]# gzip -d mybak20250910.xb.gz
/opt/xtrabackup-8.0.35-34/bin/xbstream --parallel=4 -x -v -C /home/middle/mysql8/data</opt/xtrabackup_file/mybak20250910.xb.gz

 

一步解压
[root@localhost xtrabackup_file]# cd /opt/xtrabackup_file
[root@localhost xtrabackup_file]# gzip -d -c mybak20250910.xb.gz|/opt/xtrabackup-8.0.35-34/bin/xbstream --parallel=4 -x -v -C /home/middle/mysql8/data