MySQL percona-xtrabackup 2.4.7 installation (hot spare tool)

Source: Internet
Author: User
Tags sha1 install perl percona perl script

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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.