I have an issue with my HA cluster (HA version 13.0.11), where mysql_services, mysql_ip and mysql_fs always want to failover to the slave node.
freepbx-b is currently master on all services, except for mysql, which runs on freepbx-a.When I put freepbx-a into standby, then mysql will run fine on freepbx-b.
Why does mysql not want to run on the node, that is master for all other services, like asterisk and httpd?
So I am looking at this:
pcs status when both nodes are online:
Online: [ freepbx-a freepbx-b ]
Full list of resources:
spare_ip (ocf:IPaddr2): Started freepbx-a floating_ip (ocf:IPaddr2): Started freepbx-b Master/Slave Set: ms-asterisk [drbd_asterisk] Masters: [ freepbx-b ] Slaves: [ freepbx-a ] Master/Slave Set: ms-mysql [drbd_mysql] Masters: [ freepbx-a ] Slaves: [ freepbx-b ] Master/Slave Set: ms-httpd [drbd_httpd] Masters: [ freepbx-b ] Slaves: [ freepbx-a ] Master/Slave Set: ms-spare [drbd_spare] Masters: [ freepbx-a ] Slaves: [ freepbx-b ] spare_fs (ocf:Filesystem): Started freepbx-a Resource Group: mysql mysql_fs (ocf:Filesystem): Started freepbx-a mysql_ip (ocf:IPaddr2): Started freepbx-a mysql_service (ocf:mysql): Started freepbx-a Resource Group: asterisk asterisk_fs (ocf:Filesystem): Started freepbx-b asterisk_ip (ocf:IPaddr2): Started freepbx-b asterisk_service (ocf:freepbx): Started freepbx-b Resource Group: httpd httpd_fs (ocf:Filesystem): Started freepbx-b httpd_ip (ocf:IPaddr2): Started freepbx-b httpd_service (ocf:apache): Started freepbx-b Clone Set: ClusterMon-SMTP-clone [ClusterMon-SMTP] Started: [ freepbx-a freepbx-b ] fence_a (stonith:fence_ipmilan): Started freepbx-a fence_b (stonith:fence_ipmilan): Stopped
pcs status when freepbx-a in standby:
Node freepbx-a: standbyOnline: [ freepbx-b ]
spare_ip (ocf:IPaddr2): Started freepbx-b floating_ip (ocf:IPaddr2): Started freepbx-b Master/Slave Set: ms-asterisk [drbd_asterisk] Masters: [ freepbx-b ] Stopped: [ freepbx-a ] Master/Slave Set: ms-mysql [drbd_mysql] Masters: [ freepbx-b ] Stopped: [ freepbx-a ] Master/Slave Set: ms-httpd [drbd_httpd] Masters: [ freepbx-b ] Stopped: [ freepbx-a ] Master/Slave Set: ms-spare [drbd_spare] Masters: [ freepbx-b ] Stopped: [ freepbx-a ] spare_fs (ocf:Filesystem): Started freepbx-b Resource Group: mysql mysql_fs (ocf:Filesystem): Started freepbx-b mysql_ip (ocf:IPaddr2): Started freepbx-b mysql_service (ocf:mysql): Started freepbx-b Resource Group: asterisk asterisk_fs (ocf:Filesystem): Started freepbx-b asterisk_ip (ocf:IPaddr2): Started freepbx-b asterisk_service (ocf:freepbx): Started freepbx-b Resource Group: httpd httpd_fs (ocf:Filesystem): Started freepbx-b httpd_ip (ocf:IPaddr2): Started freepbx-b httpd_service (ocf:apache): Started freepbx-b Clone Set: ClusterMon-SMTP-clone [ClusterMon-SMTP] Started: [ freepbx-b ] Stopped: [ freepbx-a ] fence_a (stonith:fence_ipmilan): Stopped fence_b (stonith:fence_ipmilan): Stopped
