Re: Packemaker resources for Galera cluster

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