If you have the ClustetIP resource in g_mysql, i think you don't need "order order_mysql_before_ip Mandatory: p_mysql ClusterIP" because the group is ordered by default, if you wanna mysql running on all boxes, use clone resource and a colocation constraint to put ip on a box with a mysql instance actived
2014-06-05 6:48 GMT+02:00 Razvan Oncioiu <[email protected]>: > Hello, > > 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 resources 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=goingforbroke \ > 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 > > > > > -- > View this message in context: > http://linux-ha.996297.n3.nabble.com/Packemaker-resources-for-Galera-cluster-tp15668.html > Sent from the Linux-HA mailing list archive at Nabble.com. > _______________________________________________ > Linux-HA mailing list > [email protected] > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems -- esta es mi vida e me la vivo hasta que dios quiera _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
