-------------------------------yum自动安装xtrabackup-----------
到官网查看xtrabackup版本及下载说明
1.Execute the following command as a root user:
$ yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
默认安装在当前用户根目录下 /root/主机名(我的为mysql)/。我把下载的安装包文件放到了 /usr/local/src
2.开始安装xtrabackup
1)解压
cd /usr/local/src/
tar zxvf percona-xtrabackup-2.1.5-680-Linux-x86_64.tar.gz
2)拷贝innobackupex、xtrabackup、xtrabackup_51 工具到/usr/bin
cp /usr/local/percona-xtrabackup-2.1.5-Linux-x86_64/bin/innobackupex /usr/bin/innobackupex
cp /usr/local/percona-xtrabackup-2.1.5-Linux-x86_64/bin/xtrabackup /usr/bin/xtrabackup
cp /usr/local/percona-xtrabackup-2.1.5-Linux-x86_64/bin/xtrabackup_55 /usr/bin/xtrabackup_55
注意 在配置文件 /etc/my.cnf 指明basedir 和 datadir
特别说明:
如果出现如下错误,说明没有装 dbi和dbd
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
则按如下步骤进行操作:
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
rpm -Uvh percona-toolkit-2.2.1-2.noarch.rpm
OK,就这么简单,安装完毕。
特别说明:
本机为:Linux mysql.example.com 2.6.18-308.el5 #1 SMP Tue Feb 21 20:06:06 EST 2012 x86_64 x86_64 x86_64 GNU/Linux
安装错误:
在yum install perl-DBD-MySQL时,出现如下错误信息
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: perl-DBD-MySQL
--> Running transaction check
---> Package mysql.x86_64 0:5.0.95-5.el5_9 set to be updated
--> Processing Conflict: mysql conflicts MySQL
--> Finished Dependency Resolution
mysql-5.0.95-5.el5_9.x86_64 from updates has depsolving problems
--> mysql conflicts with MySQL-server
Error: mysql conflicts with MySQL-server
由于我安装的是5.5.xx的MySQL版本,而系统自带的是5.0xx版本的,而libmysqlclient.so.15是由5.0版本提供的,所以就出错了。如果你的系统是centos6.X系列的,MySQL自带的为5.1以上,可能不会出现这个问题了。解决方案如下:
rpm -Uvh MySQL-shared-compat-5.5.31-1.rhel5.x86_64.rpm
MySQL-shared-compat为客户端的libraries ,向下兼容。
在yum install perl-DBD-MySQL就没有问题了。
最后测试成功
到官网查看xtrabackup版本及下载说明
1.Execute the following command as a root user:
$ yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
默认安装在当前用户根目录下 /root/主机名(我的为mysql)/。我把下载的安装包文件放到了 /usr/local/src
2.开始安装xtrabackup
1)解压
cd /usr/local/src/
tar zxvf percona-xtrabackup-2.1.5-680-Linux-x86_64.tar.gz
2)拷贝innobackupex、xtrabackup、xtrabackup_51 工具到/usr/bin
cp /usr/local/percona-xtrabackup-2.1.5-Linux-x86_64/bin/innobackupex /usr/bin/innobackupex
cp /usr/local/percona-xtrabackup-2.1.5-Linux-x86_64/bin/xtrabackup /usr/bin/xtrabackup
cp /usr/local/percona-xtrabackup-2.1.5-Linux-x86_64/bin/xtrabackup_55 /usr/bin/xtrabackup_55
注意 在配置文件 /etc/my.cnf 指明basedir 和 datadir
特别说明:
如果出现如下错误,说明没有装 dbi和dbd
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
则按如下步骤进行操作:
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
rpm -Uvh percona-toolkit-2.2.1-2.noarch.rpm
OK,就这么简单,安装完毕。
特别说明:
本机为:Linux mysql.example.com 2.6.18-308.el5 #1 SMP Tue Feb 21 20:06:06 EST 2012 x86_64 x86_64 x86_64 GNU/Linux
安装错误:
在yum install perl-DBD-MySQL时,出现如下错误信息
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: perl-DBD-MySQL
--> Running transaction check
---> Package mysql.x86_64 0:5.0.95-5.el5_9 set to be updated
--> Processing Conflict: mysql conflicts MySQL
--> Finished Dependency Resolution
mysql-5.0.95-5.el5_9.x86_64 from updates has depsolving problems
--> mysql conflicts with MySQL-server
Error: mysql conflicts with MySQL-server
由于我安装的是5.5.xx的MySQL版本,而系统自带的是5.0xx版本的,而libmysqlclient.so.15是由5.0版本提供的,所以就出错了。如果你的系统是centos6.X系列的,MySQL自带的为5.1以上,可能不会出现这个问题了。解决方案如下:
rpm -Uvh MySQL-shared-compat-5.5.31-1.rhel5.x86_64.rpm
MySQL-shared-compat为客户端的libraries ,向下兼容。
在yum install perl-DBD-MySQL就没有问题了。
最后测试成功