mysql集群_killing the zombie dump thread(-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_44555577/article/details/125887522

这篇博客详细介绍了在Linux环境下如何配置MySQL集群，包括删除默认MySQL版本、安装过程、实例化及防火墙设置。此外，还阐述了主从复制的配置步骤，如修改配置文件、设置binlog和授权从库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql集群安装配置

一、搭建mysql环境准备

1.删除linux服务器默认安装mysql版本

#查看系统是否默认安装mysql
rpm -qa | grep mariadb
#移除默认mysql安装的程序
rpm -e mariadb-libs-5.5.41-2.el7_0.x86_64 --nodeps

2.关闭防火墙

3.下载mysql rpm压缩包

4.解压mysql安装包

[root@VM-20-16-centos mysql]# tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar 
mysql-community-embedded-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-5.7.28-1.el7.x86_64.rpm
mysql-community-test-5.7.28-1.el7.x86_64.rpm
mysql-community-common-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-client-5.7.28-1.el7.x86_64.rpm
mysql-community-server-5.7.28-1.el7.x86_64.rpm

5.按照顺序安装mysql组件

[root@VM-20-16-centos mysql]# rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm 
警告：mysql-community-common-5.7.28-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:mysql-community-common-5.7.28-1.e################################# [100%]
[root@VM-20-16-centos mysql]# rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm 
警告：mysql-community-libs-5.7.28-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:mysql-community-libs-5.7.28-1.el7################################# [100%]
[root@VM-20-16-centos mysql]# 



成功案例：
[root@VM-20-16-centos mysql]# rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm 
警告：mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:mysql-community-libs-compat-5.7.2################################# [100%]

====================
失败案例：1
//❯ rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
错误：依赖检测失败：
        libcrypto.so.10()(64bit) 被 mysql-community-libs-compat-5.7.28-1.el7.x86_64 需要
        libcrypto.so.10(libcrypto.so.10)(64bit) 被 mysql-community-libs-compat-5.7.28-1.el7.x86_64 需要
        libssl.so.10()(64bit) 被 mysql-community-libs-compat-5.7.28-1.el7.x86_64 需要
        libssl.so.10(libssl.so.10)(64bit) 被 mysql-community-libs-compat-5.7.28-1.el7.x86_64 需要
root@iZ2zej1nogjvoxyena46yfZ /soft/mysql

在命令后面加如下命令即可
 
--nodeps --force
 
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm --nodeps --force


==============


[root@VM-20-16-centos mysql]# 
[root@VM-20-16-centos mysql]# 
[root@VM-20-16-centos mysql]# rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm 
警告：mysql-community-client-5.7.28-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:mysql-community-client-5.7.28-1.e################################# [100%]
[root@VM-20-16-centos mysql]# 

[root@VM-20-16-centos mysql]# 
[root@VM-20-16-centos mysql]# rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm 
警告：mysql-community-server-5.7.28-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:mysql-community-server-5.7.28-1.e################################# [100%]
[root@VM-20-16-centos mysql]# rpm -ivh mysql-commu