xtrabackup增量备份

xtrabackup下载与安装

• 下载(我这里是官网找2.4版本,centos8)

[root@host ~]# mkdir xtrabackup
[root@host ~]# cd xtrabackup/
[root@host xtrabackup]# wget https://downloads.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.22/binary/redhat/8/x86_64/Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar
--2021-05-09 16:26:07--  https://downloads.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.22/binary/redhat/8/x86_64/Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar
正在解析主机 downloads.percona.com (downloads.percona.com)... 162.220.4.221
正在连接 downloads.percona.com (downloads.percona.com)|162.220.4.221|:443... 已连接。
已发出 HTTP 请求，正在等待回应... 200 OK
长度：76595200 (73M) [application/x-tar]
正在保存至: “Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar”

Percona-XtraBackup-2.4.22-rc9 100%[==============================================>]  73.05M   746KB/s  用时 47s     

2021-05-09 16:26:57 (1.55 MB/s) - 已保存 “Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar” [76595200/76595200])

[root@host xtrabackup]# ls 
Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar

• 解压并安装

[root@host xtrabackup]# tar xf Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar 
[root@host xtrabackup]# ls
Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar
percona-xtrabackup-24-2.4.22-1.el8.x86_64.rpm
percona-xtrabackup-24-debuginfo-2.4.22-1.el8.x86_64.rpm
percona-xtrabackup-24-debugsource-2.4.22-1.el8.x86_64.rpm
percona-xtrabackup-test-24-2.4.22-1.el8.x86_64.rpm
percona-xtrabackup-test-24-debuginfo-2.4.22-1.el8.x86_64.rpm
[root@host xtrabackup]# dnf -y install percona-xtrabackup-24-2.4.22-1.el8.x86_64.rpm

将MySQL的套接字文件链接到/var/lib/mysql/mysql.scok下

[root@host ~]# mkdir /var/lib/mysql
[root@host ~]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[root@host ~]# cd /var/lib/mysql
[root@host mysql]# ls
mysql.sock

增量备份

• 创建一个存放备份文件的目录方便等下放置备份文件

[root@host /]# mkdir backup
[root@host /]# cd backup
[root@host backup]# mkdir all
[root@host backup]# mkdir all1
[root@host backup]# mkdir all2

• 将密码和用户写入配置文件

[root@host ~]# vim ~/.my.cnf
[root@host ~]# cat ~/.my.cnf
[client]
user=root
password=xialuo123!
[innobackupex]
user=