怎样进行percona-xtrabackup安装-创新互联
这篇文章给大家介绍怎样进行percona-xtrabackup安装,内容非常详细,感兴趣的小伙伴们可以参考借鉴,希望对大家能有所帮助。
成都创新互联专注于企业网络营销推广、网站重做改版、诸城网站定制设计、自适应品牌网站建设、H5页面制作、购物商城网站建设、集团公司官网建设、外贸网站建设、高端网站制作、响应式网页设计等建站业务,价格优惠性价比高,为诸城等各大城市提供网站开发制作服务。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_643. 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 --nodigestyum 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 Team5. 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安装就分享到这里了,希望以上内容可以对大家有一定的帮助,可以学到更多知识。如果觉得文章不错,可以把它分享出去让更多的人看到。
另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。
当前题目:怎样进行percona-xtrabackup安装-创新互联
链接分享:http://pwwzsj.com/article/ccsodg.html