percona-xtrabackup安装之最佳实践亲试ok-20210114最新修订

 

二进制包安装(推荐安装方式,不用安装依赖包,非常方便):
1、下载安装二进制包:
登录percona官网下载安装包即可,复制链接自动打开迅雷哦
 
2、解包并创建软连接:
[root@MHA-Master-201 softwares]# tar zxvf percona-xtrabackup-2.4.7-Linux-x86_64.tar.gz
[root@MHA-Master-201 softwares]# mv percona-xtrabackup-2.4.7-Linux-x86_64 /usr/local/xtrabackup
[root@MHA-Master-201 bin]# ln -s /usr/local/xtrabackup/bin/* /usr/bin
 
 
3、查看版本:
[root@MHA-Master-201 bin]# xtrabackup -version
xtrabackup version 2.4.7 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 05f1fcf)
 
4、备份操作
[root@localhost scripts]# innobackupex --defaults-file=/etc/my.cnf --host=127.0.0.1 --user=root --password=123456 --no-lock --use-memory=1G --slave-info --safe-slave-backup --compress --compress-threads=8 /data/backup/
 
200518 04:56:20 Backup created in directory '/data/backup/2020-05-18_04-56-14/'
MySQL binlog position: filename 'log-bin.000079', position '1263', GTID of the last change '345890d1-94eb-11ea-b693-000c295c0c44:1-5'
200518 04:56:20 [00] Compressing backup-my.cnf
200518 04:56:20 [00]        ...done
200518 04:56:20 [00] Compressing xtrabackup_info
200518 04:56:20 [00]        ...done
xtrabackup: Transaction log of lsn (2737837) to (2737846) was copied.
200518 04:56:20 completed OK!
 
创建时间:2021-12-22 09:06
浏览量:0