Shulou(Shulou.com)06/01 Report--

Ready: os is centos6.7, download and upload percona-xtrabackup installation package in advance, download URL: https://www.percona.com/downloads/XtraBackup/LATEST/

1. Install dependency packages

[root@localhost xtrabackup] # yum-y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL

Dependency Installed:

Perl-DBI.x86_64 0RO 1.609-4.el6

Complete!

two。 Install percona-xtrabackup tools

2.1-missing packages found

[root@mysql01] # rpm-ivh percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm

Warning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY

Error: Failed dependencies:

Libcurl.so.3 () (64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64

Libev.so.4 () (64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64

2.2-after configuring the local yum source, the yum found that the package was still not found. After searching, the solution for netizens is to download the libev-4.15-1.el6.rf.x86_64.rpm package separately.

2.3-install the libev-4.15-1.el6.rf.x86_64.rpm package, passed.

[root@mysql01] # rpm-ivh libev-4.15-1.el6.rf.x86_64.rpm

[root@mysql01] # rpm-ivh percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm

Warning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY

Error: Failed dependencies:

Libcurl.so.3 () (64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64

2. 4-libcurl.so.3 () (64bit) is needed by percona-xtrabackup-24-2.4.7-1.el5.x86_64, still can not be solved, and finally decided to install it forcibly. (this problem has been stuck for two hours, but it can't be solved well now. Save it for later.)

[root@mysql01] # rpm-ivh percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm-- nodeps-- force

Warning: percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY

Preparing... # [100%]

1:percona-xtrabackup-24 # # [100%]

3. Testing, viewing percona-xtrabackup version

[root@mysql01] # innobackupex-v

Innobackupex version 2.4.7 Linux (x86 / 64) (revision id: 6f7a799)

[root@mysql01 ~] # rpm-ql percona-xtrabackup-24

/ usr/bin/innobackupex

/ usr/bin/xbcloud

/ usr/bin/xbcloud_osenv

/ usr/bin/xbcrypt

/ usr/bin/xbstream

/ usr/bin/xtrabackup

Description: Xtrabackup has two main tools: xtrabackup and innobackupex

A, xtrabackup can only back up InnoDB and XtraDB data tables, but not MyISAM data tables

B, innobackupex is a perl script that encapsulates xtrabackup. Support for backing up tables of both InnoDB and MyISAM engines.

4. Test complete database

[root@mysql01] # innobackupex-- user=root-- password=oracle-- port=3606-- socket=/var/lib/mysql/mysql.sock / xtrabackup/full/

170602 06:48:07 innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.

At the end of a successful backup run innobackupex

Prints "completed OK!".

170602 06:48:07 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3606;mysql_socket=/var/lib/mysql/mysql.sock' as' root' (using password: YES).

Failed to connect to MySQL server as DBD::mysql module is not installed at-line 1327.

170602 06:48:07 Connecting to MySQL server host: localhost, user: root, password: set, port: 3606, socket: / var/lib/mysql/mysql.sock

Using server version 5.6.25

Innobackupex version 2.4.7 based on MySQL server 5.7.13 Linux (x86 / 64) (revision id: 6f7a799)

Xtrabackup: uses posix_fadvise ().

Xtrabackup: cd to / var/lib/mysql/

Xtrabackup: open files limit requested 0, set to 1024

Xtrabackup: using the following InnoDB configuration:

Xtrabackup: innodb_data_home_dir =.

Xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend

Xtrabackup: innodb_log_group_home_dir =. /

Xtrabackup: innodb_log_files_in_group = 2

Xtrabackup: innodb_log_file_size = 50331648

InnoDB: Number of pools: 1

.

170602 06:48:10 Executing UNLOCK TABLES

170602 06:48:10 All tables unlocked

170602 06:48:10 Backup created in directory'/ xtrabackup/full/2017-06-02 inch 06-48-07max'

170602 06:48:10 [00] Writing backup-my.cnf

170602 06:48:10 [00]... done

170602 06:48:10 [00] Writing xtrabackup_info

170602 06:48:10 [00]... done

Xtrabackup: Transaction log of lsn (1626027) to (1626027) was copied.

170602 06:48:10 completed OK!

5. Check backup

[root@mysql01 ~] # ll/ xtrabackup/full/

Total 4

Drwxr-x---. 5 root root 4096 Jun 2 06:53 2017-06-02 Jun 06-53-37

Description: there is no problem with the use of the tool, successful!

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.