Mailing List Archive: Packemaker resources for Galera cluster

Packemaker resources for Galera cluster

Jun 4, 2014, 9:48 PM

Post #1 of 3 (2127 views)

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
Linux-HA@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Re: Packemaker resources for Galera cluster [ In reply to ]

emi2fast at gmail

Jun 5, 2014, 6:22 AM

Post #2 of 3 (2056 views)

Permalink

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 <roncioiu@gmail.com>:
> 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
> Linux-HA@lists.linux-ha.org
> 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
Linux-HA@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Re: Packemaker resources for Galera cluster [ In reply to ]

dvossel at redhat

Jun 9, 2014, 1:48 PM

Post #3 of 3 (2053 views)

Permalink

----- Original Message -----
> From: "Razvan Oncioiu" <roncioiu@gmail.com>
> To: linux-ha@lists.linux-ha.org
> 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
> Linux-HA@lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
>
_______________________________________________
Linux-HA mailing list
Linux-HA@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems