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

[Andreas Kurz]

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>>
> 
>     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>> 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>> 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>
>             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>
>     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/fa32b309/attachment-0003.sig>