mysql备份之 Xtrabackup

mysql备份之 Xtrabackup

@author: while_box

环境:
xtrabackup version 8.0.22-15
mysql 8.0.20

1. 安装

首先从官网找到对应的二进制版本

https://www.percona.com/downloads/Percona-XtraBackup-LATEST/

wget https://downloads.percona.com/downloads/Percona-XtraBackup-LATEST/Percona-XtraBackup-8.0.22-15/binary/redhat/7/x86_64/percona-xtrabackup-80-8.0.22-15.1.el7.x86_64.rpm
yum install percona-xtrabackup-80-8.0.22-15.1.el7.x86_64.rpm -y

2. 备份

全量备份

1. 全量备份, 并压缩

mkdir -p /home/backups
cd /home/backups
xtrabackup -u root -p --backup --target-dir=/home/backups/xtrabackup/
tar -zcvf xtrabackup.tar.gz ./xtrabackup/
</