怎样进行percona-xtrabackup安装

这篇文章给大家介绍怎样进行percona-xtrabackup安装，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。

Linux系统环境：

Red Hat Enterprise Linux Server release 6.5 (Santiago)

MySQL版本：5.7.9 Source distribution

1. Install the Percona repository

[root@ora yum.repos.d]# wget [root@ora yum.repos.d]# rpm -ivh percona-release-0.1-3.noarch.rpm warning: percona-release-0.1-3.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEYPreparing...              ########################################### [100%]   1:percona-release        ########################################### [100%]

2. Testing the repository

[root@ora yum.repos.d]# yum list | grep percona-xtrabackupThis system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.percona-xtrabackup.x86_64          2.3.8-1.el6            percona-release-x86_64percona-xtrabackup-20.x86_64       2.0.8-587.rhel6        percona-release-x86_64percona-xtrabackup-20-debuginfo.x86_64percona-xtrabackup-20-test.x86_64  2.0.8-587.rhel6        percona-release-x86_64percona-xtrabackup-21.x86_64       2.1.9-746.rhel6        percona-release-x86_64percona-xtrabackup-21-debuginfo.x86_64percona-xtrabackup-22.x86_64       2.2.13-1.el6           percona-release-x86_64percona-xtrabackup-22-debuginfo.x86_64percona-xtrabackup-24.x86_64       2.4.7-2.el6            percona-release-x86_64percona-xtrabackup-24-debuginfo.x86_64percona-xtrabackup-debuginfo.x86_64percona-xtrabackup-test.x86_64     2.3.8-1.el6            percona-release-x86_64percona-xtrabackup-test-21.x86_64  2.1.9-746.rhel6        percona-release-x86_64percona-xtrabackup-test-22.x86_64  2.2.13-1.el6           percona-release-x86_64percona-xtrabackup-test-24.x86_64  2.4.7-2.el6            percona-release-x86_64

3. Install the packages

[root@ora yum.repos.d]# yum install percona-xtrabackup-24Loaded plugins: product-id, refresh-packagekit, security, subscription-managerThis system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.Setting up Install ProcessResolving Dependencies--> Running transaction check---> Package percona-xtrabackup-24.x86_64 0:2.4.7-2.el6 will be installed--> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-24-2.4.7-2.el6.x86_64--> Finished Dependency ResolutionError: Package: percona-xtrabackup-24-2.4.7-2.el6.x86_64 (percona-release-x86_64)           Requires: libev.so.4()(64bit) You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest

yum install percona-xtrabackup-21

yum install percona-xtrabackup-22

执行以上两条命令安装是没有错误提示的

percona-xtrabackup-24依赖libev.so.4()，安装对应的包即可解决

4. Install the libev-4.15-1.el6.rf.x86_64.rpm

[root@ora yum.repos.d]# wget [root@ora yum.repos.d]# rpm -ivh libev-4.15-1.el6.rf.x86_64.rpmwarning: libev-4.15-1.el6.rf.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEYPreparing...                ########################################### [100%]   1:libev                  ########################################### [100%] [root@ora yum.repos.d]# yum install percona-xtrabackup-24Loaded plugins: product-id, refresh-packagekit, security, subscription-managerThis system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.Setting up Install ProcessResolving Dependencies--> Running transaction check---> Package percona-xtrabackup-24.x86_64 0:2.4.7-2.el6 will be installed--> Finished Dependency ResolutionDependencies Resolved================================================================================================= Package                     Arch         Version             Repository                    Size=================================================================================================Installing: percona-xtrabackup-24       x86_64       2.4.7-2.el6         percona-release-x86_64       7.9 MTransaction Summary=================================================================================================Install       1 Package(s)Total download size: 7.9 MInstalled size: 31 MIs this ok [y/N]: yDownloading Packages:percona-xtrabackup-24-2.4.7-2.el6.x86_64.rpm                              | 7.9 MB     04:41     warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEYRetrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PerconaImporting GPG key 0xCD2EFD2A: Userid : Percona MySQL Development Team  Package: percona-release-0.1-3.noarch (installed) From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-PerconaIs this ok [y/N]: yRunning rpm_check_debugRunning Transaction TestTransaction Test SucceededRunning TransactionWarning: RPMDB altered outside of yum.  Installing : percona-xtrabackup-24-2.4.7-2.el6.x86_64                                      1/1   Verifying  : percona-xtrabackup-24-2.4.7-2.el6.x86_64                                      1/1 Installed:  percona-xtrabackup-24.x86_64 0:2.4.7-2.el6                                                     Complete!

5. Uninstalling Percona XtraBackup

[root@ora yum.repos.d]# yum remove percona-xtrabackup-24

6. backup database

全备的最小权限

mysql> CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY 's3cret';Query OK, 0 rows affected (0.49 sec)mysql> GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT,PROCESS ON *.* TO 'bkpuser'@'localhost';Query OK, 0 rows affected (0.00 sec)mysql> FLUSH PRIVILEGES;Query OK, 0 rows affected (0.35 sec)[root@ora backup]# innobackupex --user=bkpuser --password=s3cret --socket=/tmp/mysql.sock /oracle/app/backup170620 16:15:27 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully.           At the end of a successful backup run innobackupex           prints "completed OK!".170620 16:15:27  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/mysql.sock' as 'bkpuser'  (using password: YES).170620 16:15:28  version_check Connected to MySQL server170620 16:15:28  version_check Executing a version check against the server...170620 16:15:28  version_check Done.170620 16:15:28 Connecting to MySQL server host: localhost, user: bkpuser, password: set, port: not set, socket: /tmp/mysql.sockUsing server version 5.7.9innobackupex version 2.4.7 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 05f1fcf)xtrabackup: uses posix_fadvise().xtrabackup: cd to /oracle/app/mysql-5.7/data/xtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextendxtrabackup:   innodb_log_group_home_dir = ./xtrabackup:   innodb_log_files_in_group = 2xtrabackup:   innodb_log_file_size = 50331648InnoDB: Number of pools: 1170620 16:15:28 >> log scanned up to (2476814)省略。。。170620 16:15:36 [00]        ...done170620 16:15:36 Backup created in directory '/oracle/app/backup/2017-06-20_16-15-27/'170620 16:15:36 [00] Writing backup-my.cnf170620 16:15:36 [00]        ...done170620 16:15:36 [00] Writing xtrabackup_info170620 16:15:36 [00]        ...donextrabackup: Transaction log of lsn (2476805) to (2476814) was copied.170620 16:15:36 completed OK!backup_type说明为全备。

关于怎样进行percona-xtrabackup安装就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。