[Pacemaker] Pacemaker + MySQL master slave

[Andrew Beekhof]

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