You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

DRBD双节点高可用集群维护重启后MySQL服务无法启动的故障排查请求

DRBD双节点高可用集群维护重启后MySQL服务无法启动的故障排查请求

大家好,我这边有个双节点高可用集群,用DRBD做数据同步。最近外部公司做完维护重启系统后,MySQL资源直接停摆了,折腾半天没搞定,想请各位大佬帮忙分析下问题根源。

一、DRBD状态信息

执行drbd-overview命令后,两台节点的输出如下:

主节点(clsstd1):

0:home    Connected Primary/Secondary UpToDate/UpToDate  C r-----
1:storage Connected Secondary/Primary UpToDate/UpToDate  C r-----
2:mysql   StandAlone Secondary/Unknown UpToDate/Outdated r-----

从节点(clsstd2):

0:home    Connected Secondary/Primary UpToDate/UpToDate  C r-----
1:storage Connected Primary/Secondary UpToDate/UpToDate  C r-----
2:mysql   StandAlone Primary/Unknown UpToDate/Outdated   r-----

二、已尝试的操作与发现

  • 按照其他论坛的建议,执行了/etc/init.d/mysql start命令,但完全没用,MySQL还是启动失败。
  • 检查两台节点的/var/lib/mysql目录时,发现节点2(clsstd2)没有ibdata1文件,但节点1(clsstd1)存在这个文件,不确定这是不是关键问题。

三、MySQL错误日志(clsstd2.err)

节点2的MySQL启动日志报错信息如下:

mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql  
/usr/sbin/mysqld: Table ‘mysql.plugin’ doesn’t exist

[ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.

InnoBD: operating system error number 13 in a file operation.
InnoBD: The error means mysqld does not have access rights to the directory.
InnoBD: File name ./ibdata1
InnoBD: File operation call: ‘create’
InnoBD: Cannot continue operation

mysqld_safe mysqld from pid file /var/lib/mysql/clsstd2.pid ended

四、Pacemaker集群状态(crm_mon -1)

执行crm_mon -1查看集群资源,所有服务资源都处于停止状态:

=========
Stack: openais
Current DC: clsstd1 – partition with quorum
Version: 1.1.5-1.1.e15-01e86afaaa6da8c4836f68df80ababd6ca3902f
2 Nodes configured, 2 expected votes
4 Resources configured.
==========

Online: [ clsstd1 clsstd2 ]

Full list of resources:
Resources group all
virtual_ip_1        (ocf::heartbeat:IPaddr2):       stopped
virtual_ip_2        (ocf::heartbeat:IPaddr2):       stopped
virtual_ip_3        (ocf::heartbeat:IPaddr2):       stopped
fs_home (ocf::heartbeat:Filesystem):    stopped
fs_mysql    (ocf::heartbeat:Filesystem):    stopped
fs_storage  (ocf::heartbeat:Filesystem):    stopped
mysql       (ocf::heartbeat:mysql):     stopped
httpd       (ocf::heartbeat:apache):        stopped
swengined   (lsb:/user/lib/ocf/resource.d/streamwide/swengine):   stopped

Master/Slave Set: ms_drbd_home [drbd_home]
Masters: [ clsstd1 ]
Slaves: [ clsstd2 ]

Master/Slave Set: ms_drbd_mysql [drbd_mysql]
Masters: [ clsstd1 ]
Slaves: [ clsstd2 ]

Master/Slave Set: ms_drbd_mysql [drbd_storage]
Masters: [ clsstd1 ]
Slaves: [ clsstd2 ]

Migration summary:
*  Node clsstd1:
*  Node clsstd2:

现在完全摸不着头绪,DRBD的mysql资源状态异常(StandAlone、Outdated),加上MySQL启动时的权限和表不存在错误,想请教下各位该从哪里入手排查?

备注:内容来源于stack exchange,提问作者Iván Jf

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.04.22 15:44:36