本文共 4071 字,大约阅读时间需要 13 分钟。
准备: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-MySQL Dependency Installed: perl-DBI.x86_64 0:1.609-4.el6 Complete! 2. 安装 percona-xtrabackup 工具 2.1 -- 发现缺包 [root@mysql01 ~]# rpm -ivh percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm warning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY error: Failed dependencies: libcurl.so.3()(64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64 libev.so.4()(64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64 2.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.rpm warning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY error: Failed dependencies: libcurl.so.3()(64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64 2.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 --force warning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY Preparing... ########################################### [100%] 1:percona-xtrabackup-24 ########################################### [100%] 3. 测试,查看 percona-xtrabackup 版本 [root@mysql01 ~]# innobackupex -v innobackupex 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、innobackupex a、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 operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "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.sock Using server version 5.6.25 innobackupex 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 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 InnoDB: Number of pools: 1 。。。。 170602 06:48:10 Executing UNLOCK TABLES 170602 06:48:10 All tables unlocked 170602 06:48:10 Backup created in directory '/xtrabackup/full/2017-06-02_06-48-07/' 170602 06:48:10 [00] Writing backup-my.cnf 170602 06:48:10 [00] ...done 170602 06:48:10 [00] Writing xtrabackup_info 170602 06:48:10 [00] ...done xtrabackup: Transaction log of lsn (1626027) to (1626027) was copied. 170602 06:48:10 completed OK! 5. 检查备份 [root@mysql01 ~]# ll /xtrabackup/full/ total 4 drwxr-x---. 5 root root 4096 Jun 2 06:53 2017-06-02_06-53-37 说明:工具使用没有问题,成功! 来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31383567/viewspace-2140190/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31383567/viewspace-2140190/