I can't seem to find a proper way of setting up resources in pacemaker to manager my Galera cluster. I want a VIP that will failover betwen 5 boxes ( this works ), but I would also like to tie this into a resource that monitors mysql as well. If a mysql instance goes down, the VIP should move to another box that has mysql actually running. But I do not want pacemaker to start or stop the mysql service. Here is my current configuration:
node galera01 node galera02 node galera03 node galera04 node galera05 primitive ClusterIP IPaddr2 \ params ip=10.10.10.178 cidr_netmask=24 \ meta is-managed=true \ op monitor interval=5s primitive p_mysql mysql \ params pid="/var/lib/mysql/mysqld.pid" test_user=root test_passwd=moo \ meta is-managed=false \ op monitor interval=5s OCF_CHECK_LEVEL=10 \ op start interval=0 timeout=60s \ op stop interval=0 timeout=60s on-fail=standby group g_mysql p_mysql ClusterIP order order_mysql_before_ip Mandatory: p_mysql ClusterIP property cib-bootstrap-options: \ dc-version=1.1.10-14.el6_5.3-368c726 \ cluster-infrastructure="classic openais (with plugin)" \ stonith-enabled=false \ no-quorum-policy=ignore \ expected-quorum-votes=5 \ last-lrm-refresh=1401942846 rsc_defaults rsc-options: \ resource-stickiness=100
What am I doing wrong?