[Pacemaker] MySQL HA with pacemaker and DRBD - How to monitor mysql service

[emmanuel segura]

if you set migration-thresold=2 after two operation fail-count it's
reached your resource trys to switch to an other node

http://www.clusterlabs.org/doc/en-US/Pacemaker/1.0/html/Pacemaker_Explained/s-failure-migration.html



Il giorno 22 marzo 2012 13:51, coma <coma.inf at gmail.com> ha scritto:

> Ah yes thank you, the service status mysql is now monitored, but the
> failover is not performed?
>
>
>
>
> 2012/3/22 emmanuel segura <emi2fast at gmail.com>
>
>> sorry
>> I think you missed the op monitor operetion in your primitive definition
>>
>>
>>
>> Il giorno 22 marzo 2012 11:52, emmanuel segura <emi2fast at gmail.com> ha
>> scritto:
>>
>> I think you missed the op monitor operetion you primitive definition
>>>
>>> Il giorno 22 marzo 2012 11:33, coma <coma.inf at gmail.com> ha scritto:
>>>
>>>> Hello,
>>>>
>>>> I have a question about mysql service monitoring into a MySQL HA
>>>> cluster with pacemaker and DRBD,
>>>> I have set up a configuration to allow a failover between two nodes, it
>>>> work fine when a node is offline (or standby), but i want to know if
>>>> it is possible to monitor the mysql service to perform a failover if
>>>> mysql is stopped or unavailable?
>>>>
>>>> Thank you in advance for any response.
>>>>
>>>> My crm configuration:
>>>>
>>>> node node1 \
>>>>         attributes standby="off"
>>>> node node2 \
>>>>         attributes standby="off"
>>>> primitive Cluster-VIP ocf:heartbeat:IPaddr2 \
>>>>         params ip="x.x.x.x" broadcast="x.x.x.x" nic="eth0"
>>>> cidr_netmask="21" iflabel="VIP1" \
>>>>         op monitor interval="10s" timeout="20s" \
>>>>         meta is-managed="true"
>>>> primitive datavg ocf:heartbeat:LVM \
>>>>         params volgrpname="datavg" exclusive="true" \
>>>>         op start interval="0" timeout="30" \
>>>>         op stop interval="0" timeout="30"
>>>> primitive drbd_mysql ocf:linbit:drbd \
>>>>         params drbd_resource="drbd-mysql" \
>>>>         op monitor interval="15s"
>>>> primitive fs_mysql ocf:heartbeat:Filesystem \
>>>>         params device="/dev/datavg/data" directory="/data" fstype="ext3"
>>>> primitive mysqld lsb:mysqld
>>>> group mysql datavg fs_mysql Cluster-VIP mysqld
>>>> ms ms_drbd_mysql drbd_mysql \
>>>>         meta master-max="1" master-node-max="1" clone-max="2"
>>>> clone-node-max="1" notify="true"
>>>> location master-prefer-node-1 Cluster-VIP 25: node1
>>>> colocation mysql_on_drbd inf: mysql ms_drbd_mysql:Master
>>>> order mysql_after_drbd inf: ms_drbd_mysql:promote mysql:start
>>>> property $id="cib-bootstrap-options" \
>>>>
>>>> dc-version="1.1.5-1.1.el5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f" \
>>>>         cluster-infrastructure="openais" \
>>>>         expected-quorum-votes="2" \
>>>>         stonith-enabled="false" \
>>>>         no-quorum-policy="ignore" \
>>>>         last-lrm-refresh="1332254494"
>>>> rsc_defaults $id="rsc-options" \
>>>>         resource-stickiness="100"
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>>
>>>>
>>>
>>>
>>> --
>>> esta es mi vida e me la vivo hasta que dios quiera
>>>
>>
>>
>>
>> --
>> esta es mi vida e me la vivo hasta que dios quiera
>>
>> _______________________________________________
>> 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
>
>


-- 
esta es mi vida e me la vivo hasta que dios quiera
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20120322/4493a2d8/attachment.htm>