<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font size="-1">Hello <font size="-1">everyone.<br>
<br>
<font size="-1">I s<font size="-1">et</font> up a <font
size="-1">cluster </font></font>with <font size="-1">two
MySQL <font size="-1">nodes.<br>
<font size="-1">T<font size="-1">h<font size="-1">ere is not
only MySQL in the configura<font size="-1">tion.<br>
<br>
<font size="-1">My problem is I would like to let
MySQL up on the passive machi<font size="-1">ne to
perf<font size="-1">orm a MySQL r<font size="-1">eplication.<br>
<font size="-1">But I don't know wh<font
size="-1">y MySQL is running
automaticaly only on the active machine.<br>
<br>
<font size="-1">Here my configuration:<br>
<br>
node
$id="1575fc36-9939-4fef-856d-d2bdbe32de21"
node01<br>
node
$id="5a7efbc6-5d20-414a-8d6c-83623d5f0bfe"
node02<br>
primitive FAILOVER-IP
ocf:heartbeat:IPaddr \<br>
params ip="X.X.X.X" \<br>
op monitor interval="5s" \<br>
meta target-role="Started"<br>
primitive LSYNCD lsb:lsyncd \<br>
op monitor interval="5s" \<br>
meta target-role="Started"<br>
primitive MYSQL lsb:mysql \<br>
op monitor interval="3s" \<br>
meta target-role="Started"<br>
primitive NGINX lsb:nginx \<br>
op monitor interval="5s" \<br>
meta target-role="Started"<br>
group nginx-ha NGINX MYSQL FAILOVER-IP
LSYNCD \<br>
meta migration-threshold="3"<br>
location cli-prefer-LSYNCD LSYNCD \<br>
rule $id="cli-prefer-rule-LSYNCD"
inf: #uname eq node01<br>
location cli-prefer-nginx-ha nginx-ha
\<br>
rule
$id="cli-prefer-rule-nginx-ha" inf:
#uname eq node01<br>
property $id="cib-bootstrap-options" \<br>
dc-version="1.0.9-74392a28b7f31d7ddc86689598bd23114f58978b"
\<br>
cluster-infrastructure="Heartbeat"
\<br>
stonith-enabled="false" \<br>
last-lrm-refresh="1369651544"<br>
<br>
<font size="-1">Is this possible to
have MySQL running automaticaly on
both<font size="-1"> <font
size="-1">nodes?<br>
<br>
<font size="-1">Regards,<br>
<br>
<font size="-1">Benoît</font><br>
</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>
</body>
</html>