Preparation: OS is centos6.7, pre-download and upload percona-xtrabackup installation package, download URL: https://www.percona.com/downloads/XtraBackup/LATEST/
1. Installing dependent Packages
[Email protected] xtrabackup]# yum-y install perl perl-devel libaio libaio-devel perl-time-hires perl-dbd-mysql
Dependency installed:
Perl-dbi.x86_64 0:1.609-4.el6
complete!
2. Installing the Percona-xtrabackup tool
2.1--Missing packets found
[Email protected] ~]# 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, with Yum found still unable to find the package, after the search, the user solution 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, too.
[Email protected] ~]# RPM-IVH libev-4.15-1.el6.rf.x86_64.rpm
[Email protected] ~]# 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 cannot solve, finally decided to forcibly install. (This problem has been stuck for two hours, and now it can't be solved very well, stay to see later)
[Email protected] ~]# 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. Test, view Percona-xtrabackup version
[Email protected] ~]# innobackupex-v
Innobackupex version 2.4.7 Linux (x86_64) (revision id:6f7a799)
[Email protected] ~]# 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, Innobackupex
A, xtrabackup can only back up InnoDB and xtradb two kinds of data tables, but not the MyISAM data table
B, Innobackupex is a Perl script that encapsulates the xtrabackup. Supports the simultaneous backup of InnoDB and MyISAM engine tables.
4. Test the fully-prepared database
[Email protected] ~]# 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 was 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_06-48-07/'
170602 06:48:10 [xx] Writing backup-my.cnf
170602 06:48:10 [xx] ... done
170602 06:48:10 [xx] Writing Xtrabackup_info
170602 06:48:10 [xx] ... done
Xtrabackup:transaction Log of LSN (1626027) to (1626027) was copied.
170602 06:48:10 completed ok!
5. Check the backup
[Email protected] ~]# ll/xtrabackup/full/
Total 4
Drwxr-x---. 5 root root 4096 June 2 06:53 2017-06-02_06-53-37
Description: Tool use no problem, success!
MySQL percona-xtrabackup 2.4.7 installation (hot spare tool)