[Pacemaker] Pacemaker + MySQL master slave

Andrew Beekhof andrew at beekhof.net
Thu May 30 00:37:35 UTC 2013


On 29/05/2013, at 4:51 PM, Benoît Capitanio <benoit.capitanio at gmail.com> wrote:

> Hello everyone.
> 
> I set up a cluster with two MySQL nodes.
> There is not only MySQL in the configuration.
> 
> My problem is I would like to let MySQL up on the passive machine to perform a MySQL replication.
> But I don't know why MySQL is running automaticaly only on the active machine.

Because "normal" resources don't do that.
If you want it to run on more than one node, you need to tell the cluster that:

http://clusterlabs.org/doc/en-US/Pacemaker/1.1-crmsh/html/Pacemaker_Explained/s-resource-clone.html

or

http://clusterlabs.org/doc/en-US/Pacemaker/1.1-crmsh/html/Pacemaker_Explained/s-resource-multistate.html

> 
> Here my configuration:
> 
> node $id="1575fc36-9939-4fef-856d-d2bdbe32de21" node01
> node $id="5a7efbc6-5d20-414a-8d6c-83623d5f0bfe" node02
> primitive FAILOVER-IP ocf:heartbeat:IPaddr \
>     params ip="X.X.X.X" \
>     op monitor interval="5s" \
>     meta target-role="Started"
> primitive LSYNCD lsb:lsyncd \
>     op monitor interval="5s" \
>     meta target-role="Started"
> primitive MYSQL lsb:mysql \
>     op monitor interval="3s" \
>     meta target-role="Started"
> primitive NGINX lsb:nginx \
>     op monitor interval="5s" \
>     meta target-role="Started"
> group nginx-ha NGINX MYSQL FAILOVER-IP LSYNCD \
>     meta migration-threshold="3"
> location cli-prefer-LSYNCD LSYNCD \
>     rule $id="cli-prefer-rule-LSYNCD" inf: #uname eq node01
> location cli-prefer-nginx-ha nginx-ha \
>     rule $id="cli-prefer-rule-nginx-ha" inf: #uname eq node01
> property $id="cib-bootstrap-options" \
>     dc-version="1.0.9-74392a28b7f31d7ddc86689598bd23114f58978b" \
>     cluster-infrastructure="Heartbeat" \
>     stonith-enabled="false" \
>     last-lrm-refresh="1369651544"
> 
> Is this possible to have MySQL running automaticaly on both nodes?
> 
> Regards,
> 
> Benoît
> _______________________________________________
> 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





More information about the Pacemaker mailing list