mysql热备工具_mysql之 percona-xtrabackup 2.4.7安装（热备工具）

准备：os是centos6.7,提前下载并上传 percona-xtrabackup 安装包，下载网址为： https://www.percona.com/downloads/XtraBackup/LATEST/1.安装依赖包[root@localhost xtrabackup]# yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQLDependency Installed:perl-DBI.x86_64 0:1.609-4.el6Complete!2. 安装 percona-xtrabackup 工具2.1 -- 发现缺包[root@mysql01 ~]# rpm -ivh percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpmwarning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEYerror: Failed dependencies:libcurl.so.3()(64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64libev.so.4()(64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_642.2 -- 配置本地yum源后，用 yum 发现依然找不到包，搜寻后，网友解决方法是 单独下载 libev-4.15-1.el6.rf.x86_64.rpm 包2.3 -- 安装 libev-4.15-1.el6.rf.x86_64.rpm 包，过了。[root@mysql01 ~]# rpm -ivh libev-4.15-1.el6.rf.x86_64.rpm[root@mysql01 ~]#  rpm -ivh percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpmwarning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEYerror: Failed dependencies:libcurl.so.3()(64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_642.4 -- libcurl.so.3()(64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64 ，依然解决不了，最后决定强行安装。(这个问题卡了两个小时，现在不能很好的解决，留到以后再看)[root@mysql01 ~]# rpm -ivh percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm --nodeps --forcewarning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEYPreparing...                ########################################### [100%]1:percona-xtrabackup-24  ########################################### [100%]3. 测试，查看 percona-xtrabackup  版本[root@mysql01 ~]# innobackupex -vinnobackupex version 2.4.7 Linux (x86_64) (revision id: 6f7a799)[root@mysql01 ~]# rpm -ql percona-xtrabackup-24/usr/bin/innobackupex/usr/bin/xbcloud/usr/bin/xbcloud_osenv/usr/bin/xbcrypt/usr/bin/xbstream/usr/bin/xtrabackup说明：Xtrabackup有两个主要的工具：xtrabackup、innobackupexa、xtrabackup只能备份InnoDB和XtraDB两种数据表，而不能备份MyISAM数据表b、innobackupex是一个perl脚本封装了xtrabackup。支持同时备份InnoDB和MyISAM引擎的表。4. 测试全备数据库[root@mysql01 ~]# innobackupex --user=root --password=oracle --port=3606 --socket=/var/lib/mysql/mysql.sock  /xtrabackup/full/170602 06:48:07 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully.At the end of a successful backup run innobackupexprints "completed OK!".170602 06:48:07  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3606;mysql_socket=/var/lib/mysql/mysql.sock' as 'root'  (using password: YES).Failed to connect to MySQL server as DBD::mysql module is not installed at - line 1327.170602 06:48:07 Connecting to MySQL server host: localhost, user: root, password: set, port: 3606, socket: /var/lib/mysql/mysql.sockUsing server version 5.6.25innobackupex version 2.4.7 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 6f7a799)xtrabackup: uses posix_fadvise().xtrabackup: cd to /var/lib/mysql/xtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = ./xtrabackup:   innodb_log_files_in_group = 2xtrabackup:   innodb_log_file_size = 50331648InnoDB: Number of pools: 1。。。。170602 06:48:10 Executing UNLOCK TABLES170602 06:48:10 All tables unlocked170602 06:48:10 Backup created in directory '/xtrabackup/full/2017-06-02_06-48-07/'170602 06:48:10 [00] Writing backup-my.cnf170602 06:48:10 [00]        ...done170602 06:48:10 [00] Writing xtrabackup_info170602 06:48:10 [00]        ...donextrabackup: Transaction log of lsn (1626027) to (1626027) was copied.170602 06:48:10 completed OK!5. 检查备份[root@mysql01 ~]# ll  /xtrabackup/full/total 4drwxr-x---. 5 root root 4096 Jun  2 06:53 2017-06-02_06-53-37说明：工具使用没有问题，成功！

本文转自 张冲andy 博客园博客，原文链接：http://www.cnblogs.com/andy6/p/6931236.html   ，如需转载请自行联系原作者