[Pacemaker] Resource Stickiness

[Keith Ouellette]

Takatoshi, 
 
    I do have PostSQL running in a Master/Slave mode, however, I do not think the LSB (postgres-9.2) actually supports any master/slave functions like "promote" or "demote" My collegue believes that Pacemaker will not care and just treat both nodes as slaves. I am sort of new to Pacemaker, so I am not sure at this point if that is the case. Will it work that way?

Thanks,
Keith


________________________________________
From: Takatoshi MATSUO [matsuo.tak at gmail.com]
Sent: Friday, February 01, 2013 12:04 AM
To: The Pacemaker cluster resource manager
Subject: Re: [Pacemaker] Resource Stickiness

Hi Keith

It seems that you use LSB.

   primitive PostgreSQL lsb:postgresql-9.2

And you use it with Master/Slave.

  ms msPostresql PostgreSQL

Dose your LSB support Master/Slave configuration ?
I think  LSB can't support it.

Thanks,
Takatoshi MATSUO

2013/1/22 Keith Ouellette <Keith.Ouellette at airgas.com>:
> Sorry if this sounds like a simple issue, but for some reason I can not get
> this to work properly. I have two openSuSE servers running in a cluster (one
> Master and one Slave). I have an OCF resource defined using Ipaddr2 for a
> virtual IP (ClusterIP). The ClusterIP resource fails over to the slave if
> the Master fails as expected.
>
>
>
> However, I do not want the resource to move back to the Master automatically
> when it recovers. I saw in the "Pacemaker-1.1-Clusters_from_Scratch..."
> document in section 5.3.2, that changing the resource-stickiness to "100"
> should have given me that desired result. I tried that and the resource
> still moves back over to the Master when it recovers.
>
>
>
> Can someone tell me what I am doing wrong? Below is my full configuration.
>
>
>
> Thanks,
>
> Keith
>
>
>
> node test-db1 \
>         attributes standby="off" pgsql-data-status="LATEST"
> node test-db2 \
>         attributes standby="off" pgsql-data-status="DISCONNECT"
> primitive ClusterIP ocf:heartbeat:IPaddr2 \
>         meta target-role="Started" is-managed="true" \
>         operations $id="ClusterIP-operations" \
>         op start interval="0" timeout="60s" on-fail="stop" \
>         op monitor interval="10s" timeout="60s" on-fail="restart" \
>         op stop interval="0" timeout="60s" on-fail="block" \
>         params ip="172.16.0.110" cidr_netmask="24"
> primitive MasterDB ocf:heartbeat:Dummy \
>         meta target-role="Started" \
>         operations $id="MasterDB-operations" \
>         op monitor interval="10" timeout="20"
> primitive PostgreSQL lsb:postgresql-9.2 \
>         operations $id="PostgreSQL-operations" \
>         op monitor interval="15" timeout="15" on-fail="ignore" \
>         op start interval="0" timeout="15" on-fail="ignore" \
>         meta target-role="Started"
> ms msPostresql PostgreSQL \
>         meta clone-max="2" notify="true" target-role="Started"
> clone-node-max="1
> " master-max="1" master-node-max="1"
> property $id="cib-bootstrap-options" \
>         dc-version="1.1.6-b988976485d15cb702c9307df55512d323831a5e" \
>         cluster-infrastructure="openais" \
>         stonith-enabled="false" \
>         last-lrm-refresh="1358778294" \
>         no-quorum-policy="ignore" \
>         pe-input-series-max="0" \
>         stonith-action="poweroff" \
>         pe-warn-series-max="0" \
>         dc-deadtime="60s" \
>         expected-quorum-votes="2" \
>         start-failure-is-fatal="false" \
>         crmd-transition-delay="0" \
>         default-resource-stickiness="1000"
> rsc_defaults $id="rsc_defaults-options" \
>         resource-stickiness="100"
> op_defaults $id="op_defaults-options" \
>  record-pending="false"
>
>
>
>
> _______________________________________________
> Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
>
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs: http://bugs.clusterlabs.org
>

_______________________________________________
Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker

Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org