博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
mysql之 percona-xtrabackup 2.4.7安装(热备工具)
阅读量:2492 次
发布时间:2019-05-11

本文共 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/

你可能感兴趣的文章
代码小思考
查看>>
【NOI 2018】归程(Kruskal重构树)
查看>>
Axure原型制作规范
查看>>
Finereport集群配置
查看>>
Introspector内省和反射的区别.
查看>>
php-fpm配置笔记
查看>>
[转]解读ASP.NET 5 & MVC6系列(7):依赖注入
查看>>
[转]Asp.Net大型项目实践(11)-基于MVC Action粒度的权限管理【续】【源码在这里】(在线demo,全部源码)...
查看>>
[转]VS2010中的单元测试
查看>>
前端面试每日 3+1(每日三问)
查看>>
HC-05底层驱动
查看>>
Ruby on Rails Tutorial 第六章 用户模型
查看>>
Flex与Javascript交互
查看>>
构建之法阅读笔记03
查看>>
IOS https抓包及10.3.3版本证书不生效问题解决
查看>>
Tyvj 1921 Freda的烦恼
查看>>
SQL Server代理的阶梯 - 第2级:作业步骤和子系列
查看>>
jsoup测试例子
查看>>
Datatable/Dataset 转 JSON方法
查看>>
微信公众平台开发接口PHP SDK完整版
查看>>