分享更有价值
被信任是一种快乐

xtrabackup如何安装

文章页正文上

这篇文章主要为大家展示了“xtrabackup如何安装”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“xtrabackup如何安装”这篇文章吧。xtrabackup安装
[root@59-Mysql-Testbin]#cppercona-xtrabackup-2.1.8-733-Linux-x86_64.tar.gz/usr/src/
[root@59-Mysql-Testbin]#cd/usr/sr免费主机域名c/
[root@59-Mysql-Testbin]#tarzxvfpercona-xtrabackup-2.1.8-733-Linux-x86_64.tar.gz
[root@59-Mysql-Testbin]#cdpercona-xtrabackup-2.1.8-Linux-x86_64/
[root@59-Mysql-Testbin]#cp/usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/xtrabackup_55/usr/bin/
[root@59-Mysql-Testbin]#/usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/innobackupex–user=root–password=work123–default-file=/etc/my.cnf/data/backup/
Can’tlocateTime/HiRes.pmin@INC(@INCcontains:/usr/local/lib64/perl5/usr/local/share/perl5/usr/lib64/perl5/vendor_perl/usr/share/perl5/vendor_perl/usr/lib64/perl5/usr/share/perl5.)at/usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/innobackupexline23.
BEGINfailed–compilationabortedat/usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/innobackupexline23.
[root@59-Mysql-Testbin]#yum install perl-Time-HiRes
[root@59-Mysql-Testbin]#150807 12:28:11 innobackupex: Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_file=/data0/mysql/3306/my.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/mysql.sock’ as ‘root’ (using password: YES).
[root@userdb2bin]#yuminstallperl-DBD-MySQL
[root@59-Mysql-Testbin]#/usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/innobackupex–user=root–password=pvKsOsH7Of1AQ–defaults-file=/data0/mysql/3306/my.cnf –socket=/tmp/mysql.sock /dbbackup/
sh: xtrabackup_56: command not found
innobackupex: Error: no ‘mysqld’ group in MySQL options at /usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/innobackupex line 4357.[root@59-Mysql-Testbin]#cpxtrabackup_56/usr/bin/[root@59-Mysql-Testbin]#/usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/innobackupex–user=root–password=work123–defaults-file=/etc/my.cnf–socket=/var/lib/mysql/mysql.sock/data/backup/
[root@59-Mysql-Testmysql]#/usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/innobackupex–apply-log/data/backup/2015-08-07_11-17-04/
[root@userdb22015-08-07_12-48-23]#cd/dbbackup/2015-08-07_12-48-23/
[root@userdb22015-08-07_12-48-23]#catxtrabackup_binlo免费主机域名g_info
binlog.000659496466064
[root@59-Mysql-Testmysql]#scp-r/data/backup/2015-08-07_11-17-04/192.168.20.60:/root
[root@60-Mysql-Test2015-08-07_11-17-04]# scp-r*/var/lib/mysql
[root@60-Mysql-Testmysql]#chmod755*
[root@60-Mysql-Testmysql]#chmod755-R*
[root@60-Mysql-Testmysql]#chown-Rmysql:mysql*启动Mysql备库,并配置slave,
[root@60-Mysql-Test mysql]# service mysql start

配置数据库信息
[root@60-Mysql-Test mysql]# mysql -u root -p
mysql> stop slave; #关闭同步进程
mysql> change master to master_host=’192.168.234.62′,master_user=’bkuser’,master_password=’work123′,master_log_file=’binlog61.000010′ ,master_log_pos=107;#配置同步信息,其中File和Position是xtrabackup_binlog_info中看到的值
mysql> slave start; #开启同步进程
binlog.000679 459066612
./configure –prefix=/usr/local/mysql/ –enable-assembler –with-extra-charsets=complex –enable-thread-safe-client –with-big-tables –with-readline –with-ssl –with-embedded-server –enable-local-infile –with-plugins=partition,innobase,myisammrg
[root@sereachmysql~]#rpm-ivhpercona-xtrabackup-2.3.3-1.el6.x86_64.rpm–nodeps
innobackupex–user=root–password=work123/home/mysql/ 以上是“xtrabackup如何安装”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注云技术行业资讯频道!

相关推荐: MySQL数据库的几种常见高可用方案介绍

本篇内容主要讲解“MySQL数据库的几种常见高可用方案介绍”,感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷,实用性强。下面就让小编来带大家学习“MySQL数据库的几种常见高可用方案介绍”吧!一、概述 我们在考虑MySQL数据库的高可用的架构时,主要要考虑…

文章页内容下
赞(0) 打赏
版权声明:本站采用知识共享、学习交流,不允许用于商业用途;文章由发布者自行承担一切责任,与本站无关。
文章页正文下
文章页评论上

云服务器、web空间可免费试用

宝塔面板主机、支持php,mysql等,SSL部署;安全高速企业专供99.999%稳定,另有高防主机、不限制内容等类型,具体可咨询QQ:360163164,Tel同微信:18905205712

主机选购导航云服务器试用

登录

找回密码

注册