[need help] - MySQL in HA kept going down

the MySQL in HA kept going down every few minutes. a restart will fix but it will happen again.

i noticed that the floating IP stop working and the MySQL error will show up next. i need help on how to fix this issue

`[[email protected] ~]# pcs status
Cluster name: freepbx-ha
Last updated: Mon Mar 14 11:59:24 2016
Last change: Sun Mar 13 22:18:36 2016
Stack: cman
Current DC: freepbx-a - partition WITHOUT quorum
Version: 1.1.11-97629de
2 Nodes configured
20 Resources configured

Online: [ freepbx-a ]
OFFLINE: [ freepbx-b ]

Full list of resources:

spare_ip (ocf::heartbeat:IPaddr2): Started freepbx-a
floating_ip (ocf::heartbeat:IPaddr2): Started freepbx-a
Master/Slave Set: ms-asterisk [drbd_asterisk]
Masters: [ freepbx-a ]
Stopped: [ freepbx-b ]
Master/Slave Set: ms-mysql [drbd_mysql]
Masters: [ freepbx-a ]
Stopped: [ freepbx-b ]
Master/Slave Set: ms-httpd [drbd_httpd]
Masters: [ freepbx-a ]
Stopped: [ freepbx-b ]
Master/Slave Set: ms-spare [drbd_spare]
Masters: [ freepbx-a ]
Stopped: [ freepbx-b ]
spare_fs (ocf::heartbeat:Filesystem): Started freepbx-a
Resource Group: mysql
mysql_fs (ocf::heartbeat:Filesystem): Started freepbx-a
mysql_ip (ocf::heartbeat:IPaddr2): Started freepbx-a
mysql_service (ocf::heartbeat:mysql): Started freepbx-a
Resource Group: asterisk
asterisk_fs (ocf::heartbeat:Filesystem): Started freepbx-a
asterisk_ip (ocf::heartbeat:IPaddr2): Started freepbx-a
asterisk_service (ocf::heartbeat:freepbx): Started freepbx-a
Resource Group: httpd
httpd_fs (ocf::heartbeat:Filesystem): Started freepbx-a
httpd_ip (ocf::heartbeat:IPaddr2): Started freepbx-a
httpd_service (ocf::heartbeat:apache): Started freepbx-a

Failed actions:
floating_ip_monitor_30000 on freepbx-a ‘not running’ (7): call=23, status=complete, last-rc-change=‘Mon Mar 14 11:50:57 2016’, queued=0ms, exec=0ms`

It looks your SQL server down or disconnected?

1 Like

it’s on the same server. i am not sure what cause it to disconnect.