<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</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 bgcolor=white lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>How odd, it all seemed to work fine in testing..<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Thanks kindly for pointing it out.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>However, is there any where I can look to find out why drbd
failed from master to backup? I can’t find anything which would indicate why?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Kind regards<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> -- joe.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'>From:</span></b><span lang=EN-US
style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>
drbd-user-bounces@lists.linbit.com [mailto:drbd-user-bounces@lists.linbit.com] <b>On
Behalf Of </b>Ryan Manikowski<br>
<b>Sent:</b> 04 May 2010 16:00<br>
<b>To:</b> drbd-user@lists.linbit.com<br>
<b>Subject:</b> Re: [DRBD-user] drbd + mysql issues<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>On 5/4/2010 10:33 AM, Joe Warren-Meeks wrote: <o:p></o:p></p>
<pre>Apologies,<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Running on Ubuntu 8.04LTS<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Using:<o:p></o:p></pre><pre>ii drbd8-utils 2:8.0.11-0ubuntu3<o:p></o:p></pre><pre>RAID 1 over tcp/ip for Linux utilities<o:p></o:p></pre><pre>ii heartbeat 2.1.3-2<o:p></o:p></pre><pre>Subsystem for High-Availability Linux<o:p></o:p></pre><pre>ii fuse-utils 2.7.2-1ubuntu2.1<o:p></o:p></pre><pre>Filesystem in USErspace (utilities)<o:p></o:p></pre><pre>ii libfuse2 2.7.2-1ubuntu2.1<o:p></o:p></pre><pre>Filesystem in USErspace library<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Version: 8.0.11 (api:86)<o:p></o:p></pre><pre>GIT-hash: b3fe2bdfd3b9f7c2f923186883eb9e2a0d3a5b1b build by phil@mescal,<o:p></o:p></pre><pre>2008-02-12 11:56:43<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>/etc/drbd.conf <o:p></o:p></pre><pre><o:p> </o:p></pre><pre>global { usage-count yes; }<o:p></o:p></pre><pre>common { syncer { rate 40M; } }<o:p></o:p></pre><pre>resource r0 {<o:p></o:p></pre><pre> protocol C;<o:p></o:p></pre><pre> net {<o:p></o:p></pre><pre> cram-hmac-alg sha1;<o:p></o:p></pre><pre> shared-secret "xxxxx";<o:p></o:p></pre><pre> }<o:p></o:p></pre><pre> on d1 {<o:p></o:p></pre><pre> device /dev/drbd1;<o:p></o:p></pre><pre> disk /dev/cciss/c0d1p1;<o:p></o:p></pre><pre> address 10.10.xxx.xxx:7789;<o:p></o:p></pre><pre> meta-disk internal;<o:p></o:p></pre><pre> }<o:p></o:p></pre><pre> on d2 {<o:p></o:p></pre><pre> device /dev/drbd1;<o:p></o:p></pre><pre> disk /dev/cciss/c0d1p1;<o:p></o:p></pre><pre> address 10.10.xxx.xxx:7789;<o:p></o:p></pre><pre> meta-disk internal;<o:p></o:p></pre><pre> }<o:p></o:p></pre><pre>}<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>/etc/ha.d/haresources:<o:p></o:p></pre><pre>d1 drbddisk Filesystem::/dev/drbd1::/data::ext3 mysql 10.10.xxx.xxx<o:p></o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre>
<p class=MsoNormal><br>
<snip><br>
<br>
Your /etc/ha.d/haresources file appears to have the incorrect syntax. It should
look more like:<br>
<br>
d1 drbddisk::drbd1 \<br>
Filesystem::/dev/drbd1::/data:ext3 \<br>
mysql \<br>
IPaddr::10.10.xxx.xxx/<netmask>/<interface><br>
<br>
<br>
The errors you posted regarding mysqld not being able to locate the db
directory may be caused by the mysql daemon starting prior to the drbd device
being mounted. In that case, you may want to utilize the 'Delay' script in
ha.d/rc.d/. Here is an example:<br>
<br>
d1 drbddisk::drbd1 \<br>
Filesystem::/dev/drbd1::/data:ext3 \<br>
<b>Delay::2 \</b><br>
mysql \<br>
IPaddr::10.10.xxx.xxx/<netmask>/<interface><br>
<br>
<br>
It appears very likely your problem is not being caused by DRBD, but rather by
the heartbeat configuration.<br>
<br>
<br>
<o:p></o:p></p>
<pre>-- <o:p></o:p></pre><pre> Ryan Manikowski<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>]] Devision Media Services LLC [[<o:p></o:p></pre><pre> <a
href="http://www.devision.us">www.devision.us</a><o:p></o:p></pre><pre> <a
href="mailto:ryan@devision.us">ryan@devision.us</a> | 716.771.2282<o:p></o:p></pre></div>
</div>
</body>
</html>