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

Linux系统环境：

Red Hat Enterprise Linux Server release 6.5 (Santiago)

MySQL版本：5.7.9 Source distribution

1. Install the Percona repository

[root@orayum.repos.d]#wget[root@orayum.repos.d]#rpm-ivhpercona-release-0.1-3.noarch.rpmwarning:percona-release-0.1-3.noarch.rpm:HeaderV4DSA/SHA1Signature,keyIDcd2efd2a:NOKEYPreparing...###########################################[100%]1:percona-release###########################################[100%]

2. Testing the repository

[root@orayum.repos.d]#yumlist|greppercona-xtrabackupThissystemisnotregisteredtoRedHatSubscriptionManagement.Youcanusesubscription-managertoregister.percona-xtrabackup.x86_642.3.8-1.el6percona-release-x86_64percona-xtrabackup-20.x86_642.0.8-587.rhel6percona-release-x86_64percona-xtrabackup-20-debuginfo.x86_64percona-xtrabackup-20-test.x86_642.0.8-587.rhel6percona-release-x86_64percona-xtrabackup-21.x86_642.1.9-746.rhel6percona-release-x86_64percona-xtrabackup-21-debuginfo.x86_64percona-xtrabackup-22.x86_642.2.13-1.el6percona-release-x86_64percona-xtrabackup-22-debuginfo.x86_64percona-xtrabackup-24.x86_642.4.7-2.el6percona-release-x86_64percona-xtrabackup-24-debuginfo.x86_64percona-xtrabackup-debuginfo.x86_64percona-xtrabackup-test.x86_642.3.8-1.el6percona-release-x86_64percona-xtrabackup-test-21.x86_642.1.9-746.rhel6percona-release-x86_64percona-xtrabackup-test-22.x86_642.2.13-1.el6percona-release-x86_64percona-xtrabackup-test-24.x86_642.4.7-2.el6percona-release-x86_64

3. Install the packages

[root@orayum.repos.d]#yuminstallpercona-xtrabackup-24Loadedplugins:product-id,refresh-packagekit,security,subscription-managerThissystemisnotregisteredtoRedHatSubscriptionManagement.Youcanusesubscription-managertoregister.SettingupInstallProcessResolvingDependencies-->Runningtransactioncheck--->Packagepercona-xtrabackup-24.x86_640:2.4.7-2.el6willbeinstalled-->ProcessingDependency:libev.so.4()(64bit)forpackage:percona-xtrabackup-24-2.4.7-2.el6.x86_64-->FinishedDependencyResolutionError:Package:percona-xtrabackup-24-2.4.7-2.el6.x86_64(percona-release-x86_64)Requires:libev.so.4()(64bit)Youcouldtryusing--skip-brokentoworkaroundtheproblemYoucouldtryrunning: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@orayum.repos.d]#wget[root@orayum.repos.d]#rpm-ivhlibev-4.15-1.el6.rf.x86_64.rpmwarning:libev-4.15-1.el6.rf.x86_64.rpm:HeaderV3DSA/SHA1Signature,keyID6b8d79e6:NOKEYPreparing...###########################################[100%]1:libev###########################################[100%][root@orayum.repos.d]#yuminstallpercona-xtrabackup-24Loadedplugins:product-id,refresh-packagekit,security,subscription-managerThissystemisnotregisteredtoRedHatSubscriptionManagement.Youcanusesubscription-managertoregister.SettingupInstallProcessResolvingDependencies-->Runningtransactioncheck--->Packagepercona-xtrabackup-24.x86_640:2.4.7-2.el6willbeinstalled-->FinishedDependencyResolutionDependenciesResolved=================================================================================================PackageArchVersionRepositorySize=================================================================================================Installing:percona-xtrabackup-24x86_642.4.7-2.el6percona-release-x86_647.9MTransactionSummary=================================================================================================Install1Package(s)Totaldownloadsize:7.9MInstalledsize:31MIsthisok[y/N]:yDownloadingPackages:percona-xtrabackup-24-2.4.7-2.el6.x86_64.rpm|7.9MB04:41warning:rpmts_HdrFromFdno:HeaderV4DSA/SHA1Signature,keyIDcd2efd2a:NOKEYRetrievingkeyfromfile:///etc/pki/rpm-gpg/RPM-GPG-KEY-PerconaImportingGPGkey0xCD2EFD2A:Userid:PerconaMySQLDevelopmentTeam<mysql-dev@percona.com>Package:percona-release-0.1-3.noarch(installed)From:/etc/pki/rpm-gpg/RPM-GPG-KEY-PerconaIsthisok[y/N]:yRunningrpm_check_debugRunningTransactionTestTransactionTestSucceededRunningTransactionWarning:RPMDBalteredoutsideofyum.Installing:percona-xtrabackup-24-2.4.7-2.el6.x86_641/1Verifying:percona-xtrabackup-24-2.4.7-2.el6.x86_641/1Installed:percona-xtrabackup-24.x86_640:2.4.7-2.el6Complete!

5. Uninstalling Percona XtraBackup

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

6. backup database

全备的最小权限

mysql>CREATEUSER'bkpuser'@'localhost'IDENTIFIEDBY's3cret';QueryOK,0rowsaffected(0.49sec)mysql>GRANTRELOAD,LOCKTABLES,REPLICATIONCLIENT,PROCESSON*.*TO'bkpuser'@'localhost';QueryOK,0rowsaffected(0.00sec)mysql>FLUSHPRIVILEGES;QueryOK,0rowsaffected(0.35sec)[root@orabackup]#innobackupex--user=bkpuser--password=s3cret--socket=/tmp/mysql.sock/oracle/app/backup17062016:15:27innobackupex:StartingthebackupoperationIMPORTANT:Pleasecheckthatthebackupruncompletessuccessfully.Attheendofasuccessfulbackupruninnobackupexprints"completedOK!".17062016:15:27version_checkConnectingtoMySQLserverwithDSN'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/mysql.sock'as'bkpuser'(usingpassword:YES).17062016:15:28version_checkConnectedtoMySQLserver17062016:15:28version_checkExecutingaversioncheckagainsttheserver...17062016:15:28version_checkDone.17062016:15:28ConnectingtoMySQLserverhost:localhost,user:bkpuser,password:set,port:notset,socket:/tmp/mysql.sockUsingserverversion5.7.9innobackupexversion2.4.7basedonMySQLserver5.7.13Linux(x86_64)(revisionid:05f1fcf)xtrabackup:usesposix_fadvise().xtrabackup:cdto/oracle/app/mysql-5.7/data/xtrabackup:openfileslimitrequested0,setto1024xtrabackup:usingthefollowingInnoDBconfiguration: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:Numberofpools:117062016:15:28>>logscannedupto(2476814)省略。。。17062016:15:36[00]...done17062016:15:36Backupcreatedindirectory'/oracle/app/backup/2017-06-20_16-15-27/'17062016:15:36[00]Writingbackup-my.cnf17062016:15:36[00]...done17062016:15:36[00]Writingxtrabackup_info17062016:15:36[00]...donextrabackup:Transactionlogoflsn(2476805)to(2476814)wascopied.17062016:15:36completedOK!backup_type说明为全备。

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