前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >专栏 >使用XtraBackup创建mysql slave5

使用XtraBackup创建mysql slave5

作者头像
franket
发布于 2022-05-04 14:34:13
发布于 2022-05-04 14:34:13
43200
代码可运行
举报
文章被收录于专栏:技术杂记技术杂记
运行总次数:0
代码可运行

可知 perl-DBD-MySQL 已经安装了,和报错不符合

解决办法:

重装 perl-DBD-MySQL

代码语言:javascript
代码运行次数:0
运行
AI代码解释
复制
[root@master-qa ~]# yum list all | grep  perl-DBD-MySQL 
perl-DBD-MySQL.x86_64                      4.013-3.el6                   @base  
[root@master-qa ~]# yum reinstall  perl-DBD-MySQL.x86_64  
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Reinstall Process
Loading mirror speeds from cached hostfile
 * base: centos.ustc.edu.cn
 * extras: mirrors.pubyun.com
 * updates: centos.ustc.edu.cn
Resolving Dependencies
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be reinstalled
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Running transaction check
---> Package Percona-Server-shared-51.x86_64 0:5.1.73-rel14.12.624.rhel6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

======================================================================================================================================
 Package                             Arch              Version                                Repository                         Size
======================================================================================================================================
Reinstalling:
 perl-DBD-MySQL                      x86_64            4.013-3.el6                            base                              134 k
Installing for dependencies:
 Percona-Server-shared-51            x86_64            5.1.73-rel14.12.624.rhel6              percona-release-x86_64            2.1 M

Transaction Summary
======================================================================================================================================
Install       1 Package(s)
Reinstall     1 Package(s)

Total download size: 2.3 M
Installed size: 6.2 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): Percona-Server-shared-51-5.1.73-rel14.12.6 (1%)  1% [-                                       ]  0.0 B/s |  43 kB     --:-- ETA 
(1/2): Percona-Server-shared-51-5.1.73-rel14.12.6 (91%) 96% [=====================================- ] 177 kB/s | 2.1 MB     00:00 ETA 
(1/2): Percona-Server-shared-51-5.1.73-rel14.12.6 (93%) 99% [======================================-] 174 kB/s | 2.1 MB     00:00 ETA 

(1/2): Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6.x86_64.rpm                                           | 2.1 MB     00:10     

(2/2): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm                                                                   | 134 kB     00:00     
--------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                 208 kB/s | 2.3 MB     00:11     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction

  Installing : Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6.x86_ [####################################################### ] 1/2
  Installing : Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6.x86_64                                                          1/2 
  
  Installing : perl-DBD-MySQL-4.013-3.el6.x86_64 [############################################################################# ] 2/2
  Installing : perl-DBD-MySQL-4.013-3.el6.x86_64                                                                                  2/2 

  Verifying  : perl-DBD-MySQL-4.013-3.el6.x86_64                                                                                  1/2 

  Verifying  : Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6.x86_64                                                          2/2 

Installed:
  perl-DBD-MySQL.x86_64 0:4.013-3.el6                                                                                                 

Dependency Installed:
  Percona-Server-shared-51.x86_64 0:5.1.73-rel14.12.624.rhel6                                                                         

Complete!
[root@master-qa ~]# 

本文系转载,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文系转载,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

评论
登录后参与评论
暂无评论
推荐阅读
编辑精选文章
换一批
使用XtraBackup创建mysql slave4
到此salve的软件环境就已经准备好了 ---- 注意事项 1.slave上的数据存储位置有足够的空间,如果没有最好链接到一个有空间的位置 2.slave上使用master的配置文件,可以将有些大内存使用参数酌情改小 3.注意修改 server-id ,不能和master一样 ---- 备份master数据库 使用前面的方法在master上安装xtrabackup 报错1 [root@master-qa ~]# /usr/bin/innobackupex --defaults-file=/etc/my.cn
franket
2022/05/04
5530
mysql 5.1升级到5.61
如果有集群如mha,要停止集群,因为备份结束时会产生一个长锁,集群软件侦测到一定时间里没响应会认为master发生了故障,从而触发迁移,这不是我们想看到的~因为这会导致新恢复出来的数据不一致
franket
2022/04/16
2380
使用XtraBackup创建mysql slave1
安装percona-xtrabackup [root@slave-test src]# yum -y install percona-xtrabackup.x86_64 Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile * base: mirrors.pubyun.com * extras: mirrors.pubyun.com * upd
franket
2022/05/04
3110
mysql 迁移7
修改zabbix统计数据过期时间 [root@new-master mysql]# vim /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh [root@new-master mysql]# grep 120 /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh if [ `expr $TIMENOW - $TIMEFLM` -gt 120 ]; then [roo
franket
2022/03/21
1.5K0
nc基础用法
Netcat is a featured networking utility which reads and writes data across network connections, using the TCP/IP protocol.
franket
2022/04/23
1.2K0
mysql 迁移5
更新slave mysql版本 [root@slave02 src]# rpm -e Percona-Server-client-51-5.1.73-rel14.11.603.rhel6.x86_64 Percona-Server-server-51-5.1.73-rel14.11.603.rhel6.x86_64 Percona-Server-shared-51-5.1.73-rel14.11.603.rhel6.x86_64 error: Failed dependencies: mysql is
franket
2022/03/21
5680
nginx基础3
the HTTP rewrite module requires the PCRE library
franket
2022/05/12
3110
Mysql 监控2
这里提示我们系统里没有安装 php ,我们给它装上,同时我们也装上 php-mysql ,它提供了php 连接 mysql 需要的DBI
franket
2022/06/30
7960
mysql 5.1升级到5.67
原因为某些参数在新的版本里已经不被支持,或者将要被废弃,或者已经改成了新的名字,解决方法是查阅文档,修改配置文件
franket
2022/04/23
3000
Centos 6安装完美搭建mysql、php、apache之旅
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/116468.html原文链接:https://javaforall.cn
全栈程序员站长
2022/01/21
5960
Centos 6安装完美搭建mysql、php、apache之旅
使用XtraBackup创建mysql slave2
安装mysql [root@slave-test src]# yum install Percona-Server-server-56 Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile * base: mirrors.pubyun.com * extras: mirrors.pubyun.com * updates: mirrors.pubyun.
franket
2022/05/04
4190
安装percona-xtrabackup-24报错: file /etc/my.cnf from install of ..解决
 报错解决,可以看到现在已经成功安装了percona-xtrabackup-24。
非著名运维
2022/06/22
5870
Temporary failure in name resolution
    最近在使用yum方式安装perl-DBD-MySQL时碰到了Temporary failure in name resolution,Trying other mirror。即命名解析失败,尝试使用其它镜像。由于本机为最近安装的新服务器,下面是这个问题的现象描述及处理过程。 1、故障现象 ###当前环境 [root@GZDB ~]# cat /etc/issue CentOS release 5.11 (Final) Kernel \r on an \m [root@GZDB ~]# yum install perl-DBD-MySQL               .............. http://mirrors.pubyun.com/centos/5.11/os/x86_64/CentOS/mysql-5.0.95-5.el5_9.x86_64.rpm:     [Errno 4] IOError: <urlopen error (-3, 'Temporary failure in name resolution')> Trying other mirror. http://mirrors.sina.cn/centos/5.11/os/x86_64/CentOS/mysql-5.0.95-5.el5_9.x86_64.rpm:     [Errno 4] IOError: <urlopen error (-3, 'Temporary failure in name resolution')> Trying other mirror. Error Downloading Packages:   mysql-5.0.95-5.el5_9.x86_64: failure:       CentOS/mysql-5.0.95-5.el5_9.x86_64.rpm from base: [Errno 256] No more mirrors to try.   perl-DBI-1.52-2.el5.x86_64: failure:       CentOS/perl-DBI-1.52-2.el5.x86_64.rpm from base: [Errno 256] No more mirrors to try.   perl-DBD-MySQL-3.0007-2.el5.x86_64: failure:       CentOS/perl-DBD-MySQL-3.0007-2.el5.x86_64.rpm from base: [Errno 256] No more mirrors to try. ###尝试ping百度,结果提示未知的主机 [root@GZDB yum.repos.d]# ping www.baidu.com ping: unknown host www.baidu.com [root@GZDB yum.repos.d]# ping www.baidu.com ping: unknown host www.baidu.com 2、故障解决 ###结合上面的错误提示及无法ping通百度,应该是dns解析未配置 [root@GZDB yum.repos.d]# more /etc/resolv.conf  ###未配置dns解析 ###添加dns解析 [root@GZDB yum.repos.d]# echo " > nameserver 121.14.37.62 > nameserver 203.196.0.6">>/etc/resolv.conf [root@GZDB yum.repos.d]# ping www.baidu.com PING www.a.shifen.com (119.75.217.109) 56(84) bytes of data. 64 bytes from 119.75.217.109: icmp_seq=1 ttl=52 time=38.7 ms 64 bytes from 119.75.217.109: icmp_seq=2 ttl=52 time=38.8 ms 64 bytes from 119.75.217.109: icmp_seq=3 ttl=52 time=38.7 ms --- www.a.shifen.com ping statistics --- 3 packets transmitted, 3 received, 0% packet loss, time 6078ms rtt min/avg/max/mdev = 38.711/38.742/38.801/0.165 ms ###再次yum perl-DBD-MySQL时成功 [root@GZDB yum.repos.d]# yum install perl-DBD-MyS
Leshami
2018/08/13
3K0
RabbitMQ 的CLI管理工具 rabbitmqadmin(4)
升级Erlang [root@h102 rabbitmq]# yum update erlang.x86_64 Loaded plugins: dellsysid, fastestmirror, refresh-packagekit, security Setting up Update Process Loading mirror speeds from cached hostfile * base: mirrors.pubyun.com * epel: mirrors.opencas.cn * e
franket
2021/11/25
2730
install_driver(mysql) failed
    安装好了mysql监控神器innotop,正得意,innotoop不可用,其错误提示为install_driver(mysql) failed: Can't load '/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object  file:...经查原有又是DBD惹的祸,这个问题已经发生过好几次了。 1、故障现象 [root@dbsrv1 ~]# cat /etc/issue CentOS release 5.11 (Final) Kernel \r on an \m [root@dbsrv1 ~]# innotop localhost PROCESSLIST_NO_IS: install_driver(mysql) failed: Can't load '/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230. at (eval 504) line 3 Compilation failed in require at (eval 504) line 3. Perhaps a required shared library or dll isn't installed where expected  at /usr/bin/innotop line 7601 2、安装perl-DBD-MySQL [root@dbsrv1 ~]# yum install perl-DBD-MySQL Loaded plugins: fastestmirror, security Repository base is listed more than once in the configuration Repository updates is listed more than once in the configuration Repository extras is listed more than once in the configuration Repository centosplus is listed more than once in the configuration Repository contrib is listed more than once in the configuration Loading mirror speeds from cached hostfile  * base: mirrors.163.com  * epel: mirrors.ustc.edu.cn  * extras: mirrors.skyshe.cn  * updates: mirrors.pubyun.com Setting up Install Process Package perl-DBD-MySQL-3.0007-2.el5.x86_64 already installed and latest version Nothing to do ###上面描述已经perl-DBD-MySQL已经安装,且为最新的版本 [root@dbsrv1 yum.repos.d]# rpm -qa |grep -i dbd perl-DBD-MySQL-3.0007-2.el5 ###首先先卸载perl-DBD-MySQL,然后再次使用yum安装 [root@dbsrv1 yum.repos.d]# rpm -e --nodeps perl-DBD-MySQL-3.0007-2.el5 [root@dbsrv1 yum.repos.d]# rpm -qa |grep -i dbd [root@dbsrv1 yum.repos.d]# yum install perl-DBD-MySQL Loaded plugins: fastestmirror, security Repository base is listed more than once in the configuration Reposit
Leshami
2018/08/13
7780
Centos MySQL 5.7 安装、升级详细教程
备份数据库,升级MySQL通常不会丢失数据,但保险起见,我们需要做这一步。输入命令:
三产
2021/01/12
2.4K1
RabbitMQ管理6
消费脚本 [root@h102 python]# cat c.py #!/usr/bin/env python import pika connection = pika.BlockingConnection(pika.ConnectionParameters( host='localhost')) channel = connection.channel() channel.queue_declare(queue='mq_learning_q') print ' [*] Waiti
franket
2022/04/23
3350
Install Jumpserver30
Dependencies Resolved ========================================================================================= Package Arch Version Repository Size ========================================================================================= Installing: mariadb x86_64 1:5.5.56-2.el7 base 8.7 M mariadb-server x86_64 1:5.5.56-2.el7 base 11 M Installing for dependencies: perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k perl-DBD-MySQL x86_64 4.023-6.el7 base 140 k perl-DBI x86_64 1.627-4.el7 base 802 k perl-IO-Compress noarch 2.061-2.el7 base 260 k perl-Net-Daemon noarch 0.48-5.el7 base 51 k perl-PlRPC noarch 0.2020-14.el7 base 36 k Transaction Summary ========================================================================================= Install2 Packages (+7 Dependent packages) Total download size: 21 M Installed size: 110 M Downloading packages: (1/9): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:00 (2/9): perl-DBD-MySQL-4.023-6.el7.x86_64.rpm | 140 kB 00:00:00 (3/9): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:00 (4/9): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:00 (5/9): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00 (6/9): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:01 (7/9): mariadb-server-5.5.56-2.el7.x86_64.rpm | 11 MB 00:00:08 (8/9): mariadb-5.5.56-2.el7.x86_64.rpm
franket
2022/07/11
2560
Mysql备份系列(3)--innobackupex备份mysql大数据(全量+增量)操作记录
在日常的linux运维工作中,大数据量备份与还原,始终是个难点。关于mysql的备份和恢复,比较传统的是用mysqldump工具,今天这里推荐另一个备份工具innobackupex。innobackupex和mysqldump都可以对mysql进行热备份的,mysqldump对mysql的innodb的备份可以使用single-transaction参数来开启一个事务,利用innodb的mvcc来不进行锁表进行热备份,mysqldump备份是逻辑备份,备份出来的文件是sql语句,所以备份和恢复的时候很慢,但
洗尽了浮华
2018/01/23
2.3K0
3分钟,YUM升级MYSQL,5.1到5
本文介绍如何通过YUM升级Mysql的版本(默认用YUM安装的MySQL都是5.1的版本)
py3study
2020/01/07
7360
相关推荐
使用XtraBackup创建mysql slave4
更多 >
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档
本文部分代码块支持一键运行,欢迎体验
本文部分代码块支持一键运行,欢迎体验