xtrabackup安装

[root@59-Mysql-Testbin]#cppercona-xtrabackup-2.1.8-733-Linux-x86_64.tar.gz/usr/src/

[root@59-Mysql-Testbin]#cd/usr/src/

[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_binlog_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.000679459066612

./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/