mysql之 percona-xtrabackup 2.4.7安装(热备工具)
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysql之 percona-xtrabackup 2.4.7安装(热备工具),小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3947字,纯文字阅读大概需要6分钟。
内容图文
![mysql之 percona-xtrabackup 2.4.7安装(热备工具)](/upload/InfoBanner/zyjiaocheng/1212/e5bbcb233eb04727a978c9bff30b6929.jpg)
准备: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
说明:工具使用没有问题,成功!
原文:http://www.cnblogs.com/andy6/p/6931236.html
内容总结
以上是互联网集市为您收集整理的mysql之 percona-xtrabackup 2.4.7安装(热备工具)全部内容,希望文章能够帮你解决mysql之 percona-xtrabackup 2.4.7安装(热备工具)所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。