这篇文章给大家介绍怎样进行percona-xtrabackup安装，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。
10年积累的成都做网站、网站建设经验，可以快速应对客户对网站的新想法和需求。提供各种问题对应的解决方案。让选择我们的客户得到更好、更有力的网络服务。我虽然不认识你，你也不认识我。但先网站制作后付款的网站建设流程，更有东莞免费网站建设让你可以放心的选择与我们合作。
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: NOKEY
Preparing... ########################################### [100%]
1:percona-release ########################################### [100%]
2. Testing the repository
[root@ora yum.repos.d]# yum list | grep percona-xtrabackup
This 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_64
percona-xtrabackup-20.x86_64 2.0.8-587.rhel6 percona-release-x86_64
percona-xtrabackup-20-debuginfo.x86_64
percona-xtrabackup-20-test.x86_64 2.0.8-587.rhel6 percona-release-x86_64
percona-xtrabackup-21.x86_64 2.1.9-746.rhel6 percona-release-x86_64
percona-xtrabackup-21-debuginfo.x86_64
percona-xtrabackup-22.x86_64 2.2.13-1.el6 percona-release-x86_64
percona-xtrabackup-22-debuginfo.x86_64
percona-xtrabackup-24.x86_64 2.4.7-2.el6 percona-release-x86_64
percona-xtrabackup-24-debuginfo.x86_64
percona-xtrabackup-debuginfo.x86_64
percona-xtrabackup-test.x86_64 2.3.8-1.el6 percona-release-x86_64
percona-xtrabackup-test-21.x86_64 2.1.9-746.rhel6 percona-release-x86_64
percona-xtrabackup-test-22.x86_64 2.2.13-1.el6 percona-release-x86_64
percona-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-24
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Setting up Install Process
Resolving 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 Resolution
Error: 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.rpm
warning: libev-4.15-1.el6.rf.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
Preparing... ########################################### [100%]
1:libev ########################################### [100%]
[root@ora yum.repos.d]# yum install percona-xtrabackup-24
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package percona-xtrabackup-24.x86_64 0:2.4.7-2.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=================================================================================================
Package Arch Version Repository Size
=================================================================================================
Installing:
percona-xtrabackup-24 x86_64 2.4.7-2.el6 percona-release-x86_64 7.9 M
Transaction Summary
=================================================================================================
Install 1 Package(s)
Total download size: 7.9 M
Installed size: 31 M
Is this ok [y/N]: y
Downloading 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: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
Importing GPG key 0xCD2EFD2A:
Userid : Percona MySQL Development Team
Package: percona-release-0.1-3.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: 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/backup
170620 16:15:27 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!".
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 server
170620 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.sock
Using server version 5.7.9
innobackupex 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 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
170620 16:15:28 >> log scanned up to (2476814)
省略。。。
170620 16:15:36 [00] ...done
170620 16:15:36 Backup created in directory '/oracle/app/backup/2017-06-20_16-15-27/'
170620 16:15:36 [00] Writing backup-my.cnf
170620 16:15:36 [00] ...done
170620 16:15:36 [00] Writing xtrabackup_info
170620 16:15:36 [00] ...done
xtrabackup: Transaction log of lsn (2476805) to (2476814) was copied.
170620 16:15:36 completed OK!
backup_type说明为全备。
关于怎样进行percona-xtrabackup安装就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。
网站标题：怎样进行percona-xtrabackup安装
本文URL：
http://chengdu.cdxwcx.cn/article/ijpdhh.html
