percona XtraBackup安装

最新推荐文章于 2024-05-31 23:10:34 发布

isoleo

最新推荐文章于 2024-05-31 23:10:34 发布

阅读量702

点赞数

分类专栏： mysql 文章标签： mysql 备份

本文链接：https://blog.csdn.net/isoleo/article/details/46728815

版权

mysql 专栏收录该内容

91 篇文章 2 订阅

订阅专栏

源码安装与yum 安装，二选一

首先安装依赖包

yum install libaio libaio-devel perl-Time-HiRes curl curl-devel zlib-devel openssl-devel perl cpio expat-devel gettext-devel perl-ExtUtils-MakeMaker perl-DBD-MySQL.* package -y

如果出现如下错误：

--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: perl-DBD-MySQL
--> Running transaction check
---> Package mysql.x86_64 0:5.0.95-5.el5_9 set to be updated
--> Processing Conflict: mysql conflicts MySQL
--> Finished Dependency Resolution
mysql-5.0.95-5.el5_9.x86_64 from base has depsolving problems
--> mysql conflicts with MySQL-server
Error: mysql conflicts with MySQL-server
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
package-cleanup --dupes
rpm -Va --nofiles --nodigest

需要安装

http://mirrors.sohu.com/mysql/MySQL-5.5/MySQL-shared-compat-5.5.43-1.linux2.6.x86_64.rpm

rpm -ivh MySQL-shared-compat-5.5.43-1.linux2.6.x86_64.rpm

然后再安装依赖包

官方下载二进制包

https://www.percona.com/software/percona-xtrabackup

解压完成后，进入bin 目录，做如下操作：

ln innobackupex /usr/bin/innobackupex
ln xbcrypt /usr/bin/xbcrypt
ln xbstream /usr/bin/xbstream
ln xtrabackup /usr/bin/xtrabackup

至此就算是安装完成了。

以上为源码安装。

下边更简，yum 安装

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

查看列表

yum list | grep percona

安装xtraback

yum install percona-xtrabackup-24

测试

#innobackupex -v

innobackupex version 2.4.3 Linux (x86_64) (revision id: 6a46905)

备份

innobackupex --host=127.0.0.1 --user=lxm --password=123 --defaults-file=/data0/mha_mysql/3600/lxm.cnf --port=3600 /data0/backup/

增量备份
innobackupex --host=127.0.0.1 --user=lxm --password=123 --defaults-file=/data0/mha_mysql/3600/lxm.cnf --incremental-basedir=/data0/backup/2015-06-29_09-30-12/ --port=3600 --incremental /data0/backup/incremental/

还原步骤

1、先处理事务日志

innobackupex --apply-log --redo-only /data0/backup/2015-06-26_12-36-33/

2、还原
innobackupex --copy-back --defaults-file=/data0/mha_mysql/3601/lxm.cnf /data0/backup/2015-06-26_12-36-33/