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

Andreas Kurz andreas at hastexo.com
Thu Mar 22 14:48:18 UTC 2012


On 03/22/2012 03:23 PM, coma wrote:
> Thank you for your responses,
> 
> I have added the migration-treshold on my mysqld ressource, when i kill
> or manually stop mysql on one node, there is not failover on the second
> node.
> Also, when i look crm_mon --failcounts, i can see "mysqld:
> migration-threshold=1000000 fail-count=1000000", so i don"t anderstand
> why migration-threshold not equal 2?
> 
> Migration summary:
> * Node node1:
>    mysqld: migration-threshold=1000000 fail-count=1000000
> * Node node2:
> 
> Failed actions:
>     mysqld_monitor_10000 (node=node1, call=90, rc=7, status=complete):
> not running
>     mysqld_stop_0 (node=node1, call=93, rc=1, status=complete): unknown
> error

The lsb init script you are using seems to be not LSB compliant ...
looks like it returns an error on stopping an already stopped mysql.

http://clusterlabs.org/doc/en-US/Pacemaker/1.1/html-single/Pacemaker_Explained/index.html#ap-lsb

Fix the script ... or better use the ocf resource agent.

Regards,
Andreas

-- 
Need help with Pacemaker?
http://www.hastexo.com/now

> 
> 
> 
> 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 \
>         op monitor interval="10s" timeout="30s" \
>         op start interval="0" timeout="120" \
>         op stop interval="0" timeout="120" \
>         meta target-role="Started" migration-threshold="2"
> failure-timeout="20s"
> 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="1332425337"
> rsc_defaults $id="rsc-options" \
>         resource-stickiness="100"
> 
> 
> 
> 2012/3/22 Andreas Kurz <andreas at hastexo.com <mailto:andreas at hastexo.com>>
> 
>     On 03/22/2012 01:51 PM, coma wrote:
>     > Ah yes thank you, the service status mysql is now monitored, but the
>     > failover is not performed?
> 
>     As long as local restarts are successful there is no need for a failover
>     ... there is migration-treshold to limit local restart tries.
> 
>     Regards,
>     Andreas
> 
>     --
>     Need help with Pacemaker?
>     http://www.hastexo.com/now
> 
>     >
>     >
>     >
>     > 2012/3/22 emmanuel segura <emi2fast at gmail.com
>     <mailto:emi2fast at gmail.com> <mailto:emi2fast at gmail.com
>     <mailto: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 <mailto:emi2fast at gmail.com>
>     >     <mailto:emi2fast at gmail.com <mailto: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
>     <mailto:coma.inf at gmail.com>
>     >         <mailto:coma.inf at gmail.com <mailto: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
>     <mailto:Pacemaker at oss.clusterlabs.org>
>     >             <mailto:Pacemaker at oss.clusterlabs.org
>     <mailto: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
>     <mailto:Pacemaker at oss.clusterlabs.org>
>     >     <mailto:Pacemaker at oss.clusterlabs.org
>     <mailto: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
>     <mailto: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
>     <mailto: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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 222 bytes
Desc: OpenPGP digital signature
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20120322/3c3814e7/attachment-0004.sig>


More information about the Pacemaker mailing list