Xtrabackup下载与安装(8.0.11)

物理备份：开源最佳工具Xtrabackup下载地址：https://www.percona.com/downloads/Percona-XtraBackup-LATEST/ 1. 通过以下shell命令确认版本号rpm -qa |grep libgcryptlsb_release -a 2. 下载后解压tar -xzvf p* 3. 把软件放在/mysql/app下面mv p* /backup/app/ 4. 做软连接ln -sf p* xtrabackup 5. 加入环境变量# vim .bash_profilePATH=$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;