怎样进行percona-xtrabackup安装
admin
2023-05-18 00:41:16
0

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说明为全备。

相关内容

热门资讯

联合国秘书长欢迎黎以延长停火 新华社联合国5月16日电(记者尚绪谦)联合国秘书长发言人办公室16日说,秘书长古特雷斯欢迎黎巴嫩与以...
如何让“彩礼”回归于“礼”?一... 黄河水浇灌出的宁夏红寺堡是中国最大的生态移民安置区,宁南八县的乡音在此交汇,对美好生活的期盼与发展中...
原创 外... 外星翻译官的翻车现场:地球语言真的太难了! 银河系翻译官协会(假想机构)最近发布了一份年度报告,总...
首飞成功!已突破大重量载荷发射... 科技日报记者 付毅飞 实习生 张城辉 记者从蓝箭航天获悉,5月14日11时0分,朱雀二号改进型遥五运...
京东携手MAXHUB共推AI智... PChome消息,近日,京东与智能会议平板领域领军品牌MAXHUB正式签署战略合作协议,标志着双方战...
29个智能气象站启动业务试运行 本报北京5月15日电(记者李红梅)记者从中国气象局获悉:北京密云等29个智能气象站已于近日启动业务试...
广西一载15人车辆坠河,10人... 记者从广西环江毛南族自治县相关方面获悉,据初步了解,5月16日21时30分许,一辆汽车在环江县洛阳镇...
iOS 26.5更新苹果地图两... 苹果地图是iOS 26.5此次更新中获得新功能的应用之一。以下是地图用户需要了解的最新变化。 推荐...
每经热评 | 黄仁勋喝蜜雪冰城... 每经评论员 朱成祥 黄仁勋近期到访北京,被拍到在胡同喝豆汁、吃炸酱面、举着蜜雪冰城饮料。他表情轻松,...
我省3项目被列入工信部先进计算... 本报太原5月15日讯(记者王蕾)近日,工业和信息化部公布了2025年先进计算赋能新质生产力典型应用案...