Re: Packemaker resources for Galera cluster

----- Original Message -----
> From: "Razvan Oncioiu" <[email protected]>
> To: [email protected]
> Sent: Wednesday, June 4, 2014 11:48:01 PM
> Subject: [Linux-HA] Packemaker resources for Galera cluster
> 
> 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:

http://clusterlabs.org/doc/en-US/Pacemaker/1.1-crmsh/html-single/Pacemaker_Explained/index.html#s-resource-options

Make a cloned mysql resource and set the 'is-managed=false' meta attribute on the resource. Pacemaker will monitor if mysql is up, but not attempt to start/stop it.

Like emmanuel said, you'll need the order constraint "start mysql then start VIP."

You'll also need a colocation constraint that will force the VIP to locate to a node with an active mysql service. "colocate VIP with mysql"

so...
- make VIP resource
- make cloned mysql resource with is-managed=false
- order start start mysql-clone then VIP
- colocate VIP with mysql-clone

Good luck!

-- Vossel



> 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
> 
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems