Shulou(Shulou.com)05/31 Report--

This article introduces you how to install percona-xtrabackup, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Linux system environment:

Red Hat Enterprise Linux Server release 6.5 (Santiago)

MySQL version: 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 #

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 0vir 2.4.7-2.el6 will be installed-- > Processing Dependency: libev.so.4 () (64bit) for package: percona-xtrabackup-24-2.4.7-2.el6.x86mm 64muri-> 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

There is no error prompt to execute the above two commands to install.

Percona-xtrabackup-24 depends on libev.so.4 (), which can be solved by installing the corresponding package.

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... # [root@ora yum.repos.d] 1:libev # # 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 0vir 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 MIs this ok 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 yRunning rpm_check_debugRunning Transaction TestTransaction Test SucceededRunning TransactionWarning 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 2.el6.x86_64 1 Verifying: percona-xtrabackup-24-2.4.7-2.el6.x86_64 1 2.el6.x86_64 1 Installed: percona-xtrabackup-24.x86_64 0VR 2.4.7-2.el6 Complete!

5. Uninstalling Percona XtraBackup

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

6. Backup database

Full minimum permissions

Mysql > CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY's 3 cretters: 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) omitted. 170620 16:15:36 [00]... done170620 16:15:36 Backup created in directory'/ oracle/app/backup/2017-06-20 years 16-15-27 done170620 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 OKcargo backuploading type description is complete. On how to install percona-xtrabackup to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.