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