[Pacemaker] Pacemaker + MySQL master slave

Benoît Capitanio benoit.capitanio at gmail.com
Wed May 29 06:51:04 UTC 2013


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.

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 bothnodes?

Regards,

Benoît
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20130529/cbd5c71f/attachment-0003.html>


More information about the Pacemaker mailing list