----- 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
