物理备份：开源最佳工具Xtrabackup

下载地址：

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

1. 通过以下shell命令确认版本号

rpm -qa |grep libgcrypt

lsb_release -a

2. 下载后解压

tar -xzvf p*

3. 把软件放在/mysql/app下面

mv p* /backup/app/

4. 做软连接

ln -sf p* xtrabackup

5. 加入环境变量

# vim .bash_profile

PATH=$PATH:/mysql/backup/percona-xtrabackup-8.0.11-Linux-x86_64/bin:$HOME/bin

# source .bash_profile

6. 查看版本

xtrabackup --version

7. 创建备份用户backup并授权

create user 'backup'@'localhost' identified by 'backup';

grant reload, lock tables, process, replication client on *.* to 'backup'@'localhost';

flush privileges;