<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>
<!-- Template generated by Exclaimer Mail Disclaimers on 02:29:31 Mittwoch, 16 Mai 2012 -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">P.2e1be8e5-4bdc-4450-a7ea-0526320758af {
MARGIN: 0cm 0cm 0pt
}
LI.2e1be8e5-4bdc-4450-a7ea-0526320758af {
MARGIN: 0cm 0cm 0pt
}
DIV.2e1be8e5-4bdc-4450-a7ea-0526320758af {
MARGIN: 0cm 0cm 0pt
}
TABLE.2e1be8e5-4bdc-4450-a7ea-0526320758afTable {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</style>
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 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;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@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">
<p class="2e1be8e5-4bdc-4450-a7ea-0526320758af"></p>
<div class="WordSection1">
<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 try to get a mysql master / slave setup running, according to
<a href="http://www.e-rave.nl/prm-mysql-ha-and-pacemaker-in-the-mix">http://www.e-rave.nl/prm-mysql-ha-and-pacemaker-in-the-mix</a>. I had this setup running already, but now as we are switching from SLES to Ubuntu, I have to set it up anew.<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">Here’s the primitive for mysql:<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" style="font-family:"Courier New"">primitive p_mysql ocf:heartbeat:mysql \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Courier New""> params config="/etc/mysql/my.cnf" log="/var/log/mysql.err" additional_parameters="--debug" pid="/var/run/mysqld/mysqld.pid" socket="/var/run/mysqld/mysqld.sock" replication_user="repl"
replication_passwd="***" max_slave_lag="15" evict_outdated_slaves="false" binary="/usr/sbin/mysqld" test_user="root" test_passwd="***" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Courier New""> op monitor interval="20s" role="Master" OCF_CHECK_LEVEL="1" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Courier New""> op monitor interval="30s" role="Slave" timeout="30s" OCF_CHECK_LEVEL="1" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Courier New""> op start interval="0" timeout="120s" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Courier New""> op stop interval="0" timeout="120s"<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">and here’s the master-slave-resource:<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" style="font-family:"Courier New"">ms ms_MySQL p_mysql \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Courier New""> meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true" globally-unique="false<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">Some part of it works, as the replication info is available:<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">property $id="mysql_replication" \<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> replication_info="10.10.0.101|mysql-bin.000005|107"<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">Still, the agent fails, as crm_mon reports:<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" style="font-family:"Courier New"">Failed actions:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Courier New""> p_mysql:0_start_0 (node=proto-cms-appl01, call=22, rc=-2, status=Timed Out): unknown exec error<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Courier New""> p_mysql:1_start_0 (node=proto-cms-appl02, call=21, rc=-2, status=Timed Out): unknown exec error<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">Starting mysql by hand with </span><span lang="EN-US" style="font-family:"Courier New"">service mysql start</span><span lang="EN-US"> works nicely, while ocf-tester –v –n p_mysql –o … /usr/lib…/mysql keeps on reporting
<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" style="font-family:"Courier New"">mysql[20688]: ERROR: MySQL is not running<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">and never (!) ends, unless it is killed via CTRL-C.<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 find nothing of any (obvious) relevance in /var/log/syslog besides
<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" style="font-family:"Courier New"">May 16 13:27:20 proto-cms-appl01 mysql[1300]: ERROR: ERROR 1210 (HY000) at line 1: Incorrect arguments to MASTER_HOST<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Courier New"">May 16 13:27:20 proto-cms-appl01 mysql[1300]: ERROR: Failed to set master<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">which is from one hour ago.<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">mysqld.log, mysql.err, and mysql.log under /var/log/ stay empty, as well as the directory /var/log/mysql.<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">Any ideas?<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">Cheers,<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">BTW: Does anyone else feel, that “unknown exec error” is not the most informative way to report an error? It would be nice if the “verbosity” could somehow be increased. What do you think?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">PS: Yves, if you happen to read this: Are there any updates due for your mysql resource agent? When will it be included into the regular pacemaker-resource-agents package?<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" style="color:blue">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>
<p></p>
<p class="2e1be8e5-4bdc-4450-a7ea-0526320758af"> </p>
<p class="2e1be8e5-4bdc-4450-a7ea-0526320758af">----------------------------<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 </p>
<p class="2e1be8e5-4bdc-4450-a7ea-0526320758af"> ----------------------------</p>
<p class="2e1be8e5-4bdc-4450-a7ea-0526320758af"> </p>
<p class="2e1be8e5-4bdc-4450-a7ea-0526320758af"></p>
</body>
</html>