In a 2 db prm cluster the VIPs became unresponsive. Further digging the VIPs lost their MAC addresses. I am puzzled to how and why. Any help would be great.
node db1 \
attributes p_mysql_mysql_master_IP="192.168.10.5" standby="off"
node db2 \
attributes p_mysql_mysql_master_IP="192.168.10.6" standby="off"
primitive db_reader_vip1 ocf:heartbeat:IPaddr2 \
params ip="192.168.10.106" nic="eth0" cidr_netmask="24" \
op monitor interval="10s" \
meta target-role="Started"
primitive db_reader_vip2 ocf:heartbeat:IPaddr2 \
params ip="192.168.10.107" nic="eth0" cidr_netmask="24" \
op monitor interval="10s" \
meta target-role="Started"
primitive db_writer_vip ocf:heartbeat:IPaddr2 \
params ip="192.168.10.105" nic="eth0" cidr_netmask="24" \
op monitor interval="10s" \
meta target-role="Started"
primitive p_mysql ocf:percona:mysql \
params config="/etc/mysql/my.cnf" datadir="/var/lib/mysql" pid="/var/run/mysqld/mysqld.pid" socket="/var/run/mysqld/mysqld.sock" replication_user="replicantfakeuser" replication_passwd="*************************" max_slave_lag="60" evict_outdated_slaves="false" binary="/usr/sbin/mysqld" test_user="thisisafaketestuser" test_passwd="*****************" async_stop="1" additional_parameters="--log-error=/var/lib/mysql/mysql_err.log" \
op monitor interval="5s" role="Master" timeout="30s" ocf_check_level="1" \
op monitor interval="2s" role="Slave" timeout="30s" ocf_check_level="1" \
op start interval="0" timeout="180s" \
op stop interval="0" timeout="180s" \
meta target-role="Started"
ms ms_MySQL p_mysql \
meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true" globally-unique="false" target-role="Master" is-managed="true"
location cli-prefer-db_reader_vip1 db_reader_vip1 \
rule $id="cli-prefer-rule-db_reader_vip1" inf: #uname eq db1
location cli-prefer-db_reader_vip2 db_reader_vip2 \
rule $id="cli-prefer-rule-db_reader_vip2" inf: #uname eq db2
location db1_master ms_MySQL \
rule $id="db1-master-rule" $role="Master" 7000: #uname eq db1
location db2_master ms_MySQL \
rule $id="db2-master-rule" $role="Master" 2500: #uname eq db2
location loc-no-db-reader-vip-1 db_reader_vip1 \
rule $id="loc-no-db-reader-vip-1-rule" -inf: readable lt 1
location loc-no-db-reader-vip2 db_reader_vip2 \
rule $id="loc-no-db-reader-vip2-rule" -inf: readable lt 1
colocation col_reader1_dislike_reader2 -200: db_reader_vip1 db_reader_vip2
colocation col_reader1_dislike_writer -200: db_reader_vip1 db_writer_vip
colocation col_reader2_dislike_writer -200: db_reader_vip2 db_writer_vip
colocation db_writer_vip_on_master inf: db_writer_vip ms_MySQL:Master
order ms_MySQL_promote_before_vip inf: ms_MySQL:promote db_writer_vip:start
property $id="cib-bootstrap-options" \
dc-version="1.1.6-9971ebba4494012a93c03b40a2c58ec0eb60f50c" \
cluster-infrastructure="openais" \
expected-quorum-votes="2" \
no-quorum-policy="ignore" \
stonith-enabled="false" \
last-lrm-refresh="1481632624" \
maintenance-mode="false"
property $id="mysql_replication" \
p_mysql_REPL_INFO="192.168.10.5|master-bin.000003|866604"