<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Sprechblasentext Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
p.35e3068e-0c72-4aee-a6e2-9106d9d49ed9, li.35e3068e-0c72-4aee-a6e2-9106d9d49ed9, div.35e3068e-0c72-4aee-a6e2-9106d9d49ed9
{mso-style-name:35e3068e-0c72-4aee-a6e2-9106d9d49ed9;
mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.E-MailFormatvorlage19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.E-MailFormatvorlage20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.E-MailFormatvorlage21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.SprechblasentextZchn
{mso-style-name:"Sprechblasentext Zchn";
mso-style-priority:99;
mso-style-link:Sprechblasentext;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Just forget what I wrote. It was some mysql password issue. ARGH!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:gray;mso-fareast-language:DE">--<br>
CONET Solutions GmbH<br>
Andreas Stallmann, <br>
Theodor-Heuss-Allee 19, 53773 Hennef<br>
Tel.: +49 2242 939-677, Fax: +49 2242 939-393<br>
Mobil: +49 172 2455051<br>
Internet: http://www.conet.de, mailto: </span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:gray;mso-fareast-language:DE"><a href="mailto:AStallmann@CONET.DE"><span lang="EN-US">AStallmann@CONET.DE</span></a></span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:gray;mso-fareast-language:DE">
</span><span lang="EN-US"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:DE">Von:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:DE"> Stallmann, Andreas [mailto:AStallmann@CONET.DE]
<br>
<b>Gesendet:</b> Freitag, 10. Februar 2012 16:03<br>
<b>An:</b> The Pacemaker cluster resource manager<br>
<b>Betreff:</b> Re: [Pacemaker] Replacement for LVSSyncDaemonSwap-RA?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Sorry for bothering you. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">I just found out that LVSSyncDaemonSwap is not necessary any more with newer ldirector version.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Ahhehm… one more question (and I not that this question is entirely out of place her):<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Does anyone here know anything about ldirector? I just wonder:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">When you configure ldirector to listen on port 3306, shouldn’t this port show up as “listen” in lsof –i? Because it doesn’t (and access to the balanced hosts via the virtual IP does not work).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Here’s my crm-config:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">node ubuntu-lb01<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">node ubuntu-lb02<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">primitive p_loadbalancer ocf:heartbeat:ldirectord \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> params configfile="/etc/ldirectord.cf" ldirectord="/usr/sbin/ldirectord" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> op start interval="0" timeout="15s" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> op stop interval="0" timeout="15s" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> op monitor interval="20s" timeout="10s" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> meta target-role="Started"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">primitive p_writer_vip ocf:heartbeat:IPaddr2 \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> params ip="10.20.0.13" cidr_netmask="24" nic="eth0:0" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> meta target-role="Started"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">group g_loadbalance p_writer_vip p_loadbalancer<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">location cli-prefer-g_loadbalance g_loadbalance \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> rule $id="cli-prefer-rule-g_loadbalance" inf: #uname eq ubuntu-lb01<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">property $id="cib-bootstrap-options" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> dc-version="1.1.5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> cluster-infrastructure="openais" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> expected-quorum-votes="2" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> stonith-enabled="false" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> no-quorum-policy="ignore" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> default-resource-stickiness="1000" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> last-lrm-refresh="1328884725"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">And here’s the config of ldirector:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"># Global Directives<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">checktimeout=10<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">checkinterval=2<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">autoreload=no<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">logfile="local0"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">quiescent=yes<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">virtual = 10.20.0.13:3306<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> service = mysql<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> real = 10.20.0.14:3306 gate<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> real = 10.20.0.15:3306 gate<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> checktype = negotiate<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> login = "ldirector"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> passwd = "ldirectorpassword"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> database = "ldirectordb"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> request = "SELECT * FROM connectioncheck"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> scheduler = wrr<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Any ideas?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Andreas<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:gray;mso-fareast-language:DE">--<br>
CONET Solutions GmbH<br>
Andreas Stallmann, <br>
Theodor-Heuss-Allee 19, 53773 Hennef<br>
Tel.: +49 2242 939-677, Fax: +49 2242 939-393<br>
Mobil: +49 172 2455051<br>
Internet: <a href="http://www.conet.de">http://www.conet.de</a>, mailto: </span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:gray;mso-fareast-language:DE"><a href="mailto:AStallmann@CONET.DE"><span lang="EN-US">AStallmann@CONET.DE</span></a>
</span><span lang="EN-US"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:DE">Von:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:DE"> Stallmann, Andreas
<a href="mailto:[mailto:AStallmann@CONET.DE]">[mailto:AStallmann@CONET.DE]</a> <br>
<b>Gesendet:</b> Freitag, 10. Februar 2012 15:14<br>
<b>An:</b> <a href="mailto:pacemaker@oss.clusterlabs.org">pacemaker@oss.clusterlabs.org</a><br>
<b>Betreff:</b> [Pacemaker] Replacement for LVSSyncDaemonSwap-RA?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">Hi!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I’m trying to set up a loadbalanced MySQL-Cluster (according to
<a href="http://www.howtoforge.com/setting-up-a-loadbalanced-mysql-cluster-with-mysql5.1-p3">
http://www.howtoforge.com/setting-up-a-loadbalanced-mysql-cluster-with-mysql5.1-p3</a>). Unfortunately the manual is from 2008 and thus uses heartbeat, while I prefer corosync/pacemaker. *<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Do you know which Ubuntu (11.10) package contains the LVSSyncDaemonSwap-RA? It’s not in the resource-agents package.
</span><span lang="EN-US" style="font-family:Wingdings">L</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks in advance,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Andreas<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">*Yes, I know, there’s keepalived out there, but I don’t find a manual how to set it up for MySQL.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:gray;mso-fareast-language:DE">--<br>
CONET Solutions GmbH<br>
Andreas Stallmann, <br>
Theodor-Heuss-Allee 19, 53773 Hennef<br>
Tel.: +49 2242 939-677, Fax: +49 2242 939-393<br>
Mobil: +49 172 2455051<br>
Internet: <a href="http://www.conet.de">http://www.conet.de</a>, mailto: </span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:gray;mso-fareast-language:DE"><a href="mailto:AStallmann@CONET.DE"><span lang="EN-US">AStallmann@CONET.DE</span></a>
</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="35e3068e-0c72-4aee-a6e2-9106d9d49ed9"> <o:p></o:p></p>
<p class="35e3068e-0c72-4aee-a6e2-9106d9d49ed9">----------------------------<br>
CONET Solutions GmbH, Theodor-Heuss-Allee 19, 53773 Hennef.<br>
Registergericht/Registration Court: Amtsgericht Siegburg (HRB Nr. 9136)<br>
Geschäftsführer/Managing Director: Anke Höfer <o:p></o:p></p>
<p class="35e3068e-0c72-4aee-a6e2-9106d9d49ed9"> ----------------------------<o:p></o:p></p>
<p class="35e3068e-0c72-4aee-a6e2-9106d9d49ed9"> <o:p></o:p></p>
</div>
</body>
</html>