cluster (corosync, pacemaker, drbd, mysql) lost communication between nodes
we have setup one cluster with two nodes.
sometimes, we loose connection between the two nodes (node 1 and node 2). When this happens, the two nodes starts both the services as masters,because they don't see each other.
is there any way to tell to one node when connection is lost, for example " see if sec_vip of mysql is up. If so, do start the service drbd but not as master, do not start mysql, and do not start sec_vip. So in such way, only one node will be the master and we wouldnt have duplicated logs on databases or lost transactions.
Thank u very much for your time!!