Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to install xtrabackup", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to install xtrabackup" this article.

Xtrabackup installation

[root@59-Mysql-Test bin] # cp percona-xtrabackup-2.1.8-733-Linux-x86_64.tar.gz / usr/src/

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

[root@59-Mysql-Test bin] # tar zxvf percona-xtrabackup-2.1.8-733-Linux-x86_64.tar.gz

[root@59-Mysql-Test bin] # cd percona-xtrabackup-2.1.8-Linux-x86_64/

[root@59-Mysql-Test bin] # cp / usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/xtrabackup_55 / usr/bin/

[root@59-Mysql-Test bin] # / usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/innobackupex-user=root-password=work123-default-file=/etc/my.cnf / data/backup/

Can't locate Time/HiRes.pm in @ INC (@ INC contains: / 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/innobackupex line 23.

BEGIN failed--compilation aborted at / usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/innobackupex line 23.

[root@59-Mysql-Test bin] # yum install perl-Time-HiRes

[root@59-Mysql-Test bin] # 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@userdb2 bin] # yum install perl-DBD-MySQL

[root@59-Mysql-Test bin] # / 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-Test bin] # cp xtrabackup_56 / usr/bin/

[root@59-Mysql-Test bin] # / 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-Test mysql] # / usr/src/percona-xtrabackup-2.1.8-Linux-x86_64/bin/innobackupex-- apply-log / data/backup/2015-08-07 / 11-17-04 /

[root@userdb2 2015-08-07 12-48-23] # cd / dbbackup/2015-08-07 12-48-23 /

[root@userdb2 2015-08-07 / 12-48-23] # cat xtrabackup_binlog_info

Binlog.000659 496466064

[root@59-Mysql-Test mysql] # scp-r / data/backup/2015-08-07 / 11-17-04 / 192.168.20.60:/root

[root@60-Mysql-Test 2015-08-07 July 11-17-04] # scp-r * / var/lib/mysql

[root@60-Mysql-Test mysql] # chmod 755 *

[root@60-Mysql-Test mysql] # chmod 755-R *

[root@60-Mysql-Test mysql] # chown-R mysql:mysql *

Start the MySQL repository and configure slave

[root@60-Mysql-Test mysql] # service mysql start

Configure database information

[root@60-Mysql-Test mysql] # mysql-u root-p

Mysql > stop slave; # turn off the synchronization process

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

# configure synchronization information, where File and Position are the values seen in xtrabackup_binlog_info

Mysql > slave start; # start the synchronization process

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-ivh percona-xtrabackup-2.3.3-1.el6.x86_64.rpm-- nodeps

Innobackupex-user=root-password=work123 / home/mysql/

These are all the contents of the article "how to install xtrabackup". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.