错误一: error: Failed dependencies:
libaio.so.1()(64bit) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
libaio.so.1(LIBAIO_0.1)(64bit) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
libaio.so.1(LIBAIO_0.4)(64bit) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
perl(DBD::mysql) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
perl(Time::HiRes) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
解决方法: yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL
错误二:Can’t call method “disconnect” on an undefined value at /usr/bin/innobackupex line 1477.
解决方法:尚未解决,敬请了解的同学告知!感激不尽;
错误三:innobackupex: Connecting to MySQL server with DSN
‘dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup’ as ‘root’ (using
password: YES).
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at
/usr/bin/innobackupex line
解决方法:没有装 dbi和dbd;也可能是没有指定–user和–password以及权限问题
则按如下步骤进行操作:
Percona Toolkit 的安装:
1:下载percona toolkit的包:(可以是源码包,或者RPM)
访问:http://www.percona.com/software/percona-toolkit/ 下载最新稳定的版本。也可以如下命令行的方式下载最新版本。
wget percona.com/get/percona-toolkit.tar.gz
wget percona.com/get/percona-toolkit.rpm
2:安装于Perl相关的模块
yum install perl-DBI
yum install perl-DBD-MySQL
yum install perl-Time-HiRes
yum install perl-IO-Socket-SSL
3: 安装Percona Toolkit
安装之前需要安装perl-TermReadKey,否则会报错:
error: Failed dependencies:
perl(Term::ReadKey) is needed by percona-toolkit-2.2.17-1.noarch
下载该包:wget http://pkgs.repoforge.org/perl-TermReadKey/perl-TermReadKey-2.30-1.el5.rf.x86_64.rpm
安装该包:rpm -ivh perl-TermReadKey-2.30-1.el5.rf.x86_64.rpm
安装成功后则可以继续安装percona-toolkit
rpm -Uvh percona-toolkit-2.2.1-2.noarch.rpm
libaio.so.1()(64bit) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
libaio.so.1(LIBAIO_0.1)(64bit) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
libaio.so.1(LIBAIO_0.4)(64bit) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
perl(DBD::mysql) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
perl(Time::HiRes) is needed by percona-xtrabackup-2.2.3-4982.el6.x86_64
解决方法: yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL
错误二:Can’t call method “disconnect” on an undefined value at /usr/bin/innobackupex line 1477.
解决方法:尚未解决,敬请了解的同学告知!感激不尽;
错误三:innobackupex: Connecting to MySQL server with DSN
‘dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup’ as ‘root’ (using
password: YES).
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at
/usr/bin/innobackupex line
解决方法:没有装 dbi和dbd;也可能是没有指定–user和–password以及权限问题
则按如下步骤进行操作:
Percona Toolkit 的安装:
1:下载percona toolkit的包:(可以是源码包,或者RPM)
访问:http://www.percona.com/software/percona-toolkit/ 下载最新稳定的版本。也可以如下命令行的方式下载最新版本。
wget percona.com/get/percona-toolkit.tar.gz
wget percona.com/get/percona-toolkit.rpm
2:安装于Perl相关的模块
yum install perl-DBI
yum install perl-DBD-MySQL
yum install perl-Time-HiRes
yum install perl-IO-Socket-SSL
3: 安装Percona Toolkit
安装之前需要安装perl-TermReadKey,否则会报错:
error: Failed dependencies:
perl(Term::ReadKey) is needed by percona-toolkit-2.2.17-1.noarch
下载该包:wget http://pkgs.repoforge.org/perl-TermReadKey/perl-TermReadKey-2.30-1.el5.rf.x86_64.rpm
安装该包:rpm -ivh perl-TermReadKey-2.30-1.el5.rf.x86_64.rpm
安装成功后则可以继续安装percona-toolkit
rpm -Uvh percona-toolkit-2.2.1-2.noarch.rpm
0
- 参考文档
- XtraBackup X--backup
- http://www.cnblogs.com/Amaranthus/archive/2014/08/19/3922570.html
- http://www.cnblogs.com/cosiray/archive/2012/03/02/2376595.html
- Xtrabackup是一个对InnoDB做数据备份的工具,支持在线热备份,备份过程不锁表,不受时间限制,不影响用户使用。
- 每日备份只产生少量数据,远程备份传输更方便。同时节省空间。
- 生产环境要求
- 1. /etc/my.cnf中 需要设置datadir default_table_type = InnoDB
- 2.MySQL InnoDB在5.1这个版本不支持。可以使用Percona XtraBackup 2,或升级到InnoDB Plugin
- 1.命令安装:
- yum install -y gnupg
- rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
- yum install -y percona-xtrabackup
- [root@aliyun-112 ~]# xtrabackup -v
- xtrabackup version 2.3.3 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 525ca7d)
- 2.命令功能:
- 对InnoDB做数据备份的工具,支持在线热备份
- 3.命令参数:
- --database=sundong 单独对sundong数据库做备份 ,若是不添加此参数那就那就是对全库做备份
- --stream =tar 打包格式 目前只支持 tar and xbstream
- 2>/var/backups/sundong.log 输出信息写入日志中
- 1> /var/backups/sundong.tar.gz 打包压缩存储到该文件中
- --incremental-dir=/var/backups/plus/ 增量备份目录
- --copy-back选项的命令从备份目录拷贝数据,索引,日志到my.cnf文 件里规定的初始位置
- --apply-log选项的命令是准备在一个备份上启动mysql服务
- --port=PORT
- 4.命令实例:
- 备份并打包压缩
- innobackupex --defaults-file=/home/DB/mysql/my.cnf --user=root --password=sundong@123 --database=sundong --stream=tar /var/backups/ 2>/var/backups/sundong.log | gzip 1> /var/backups/sundong.tar.gz
- 此处可以写个脚本做备份(backup.sh)
- [root@wh-cnc-51 backups]# cat backup.sh
- #!/bin/sh
- echo "begin..."`date`
- log=sundong_`date +%F`.log
- str=sundong_`date +%F`.tar.gz
- innobackupex --defaults-file=/home/DB/mysql/my.cnf --user=root --password=sundong@123 --database=sundong --stream=tar /var/backups/ 2>/var/backups/$log | gzip 1> /var/backups/$str
- echo "completed OK..."`date
- [root@wh-cnc-51 backups]# sh -x backup.sh
- ++ date
- + echo begin...Mon Jan 4 15:05:08 CST 2016
- begin...Mon Jan 4 15:05:08 CST 2016
- ++ date +%F
- + log=sundong_2016-01-04.log
- ++ date +%F
- + str=sundong_2016-01-04.tar.gz
- + gzip
- + innobackupex --defaults-file=/home/DB/mysql/my.cnf --user=root --password=sundong@123 --database=sundong --stream=tar /var/backups/
- ++ date
- + echo 'completed OK...Mon' Jan 4 15:05:11 CST 2016
- completed OK...Mon Jan 4 15:05:11 CST 2016
- [root@wh-cnc-51 backups]# ll
编辑回复