<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=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<title>ProActive Software</title>
<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;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#25AAE1;
text-decoration:none none;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#25AAE1;
text-decoration:none none;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
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;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
color:black;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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 bgcolor="white" lang="EN-US" link="#25AAE1" vlink="#25AAE1">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">rsync will not be able to synchronize from a “failed” disk, drbd already has done so.<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">Dan in Atlanta<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:0in 0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">From:</span></b><span 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>Robinson, Eric<br>
<b>Sent:</b> Wednesday, June 12, 2013 6:20 PM<br>
<b>To:</b> Dirk Bonenkamp - ProActive<br>
<b>Cc:</b> drbd-user@lists.linbit.com<br>
<b>Subject:</b> Re: [DRBD-user] drbd+mysql+innodb<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi Dirk – Thanks for the feedback. I do need some clarification, though. DRBD replicates disk block changes to a standby volume. If the primary node suddenly
fails, the cluster manager promotes the standby node to primary and starts the MySQL service. Logically, this seems exactly the same as simply rsyncing the data to the new server and starting the MySQL service. Why would it work with DRBD but not with rsync?
Thanks for your patience while I explore this.<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">Note: we have over 500 separate MySQL database instances using MyISAM. I am totally not stoked about the idea of using 300% more disk space and gobs more memory.<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>
<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">Eric Robinson<o:p></o:p></span></p>
</div>
<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"><o:p> </o:p></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext"> Dirk Bonenkamp - ProActive [<a href="mailto:dirk@proactive.nl">mailto:dirk@proactive.nl</a>]
<br>
<b>Sent:</b> Wednesday, June 12, 2013 7:24 AM<br>
<b>To:</b> Robinson, Eric<br>
<b>Cc:</b> <a href="mailto:drbd-user@lists.linbit.com">drbd-user@lists.linbit.com</a><br>
<b>Subject:</b> Re: [DRBD-user] drbd+mysql+innodb<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi Eric,<br>
<br>
We did the same conversion about a year ago. We run MySQL with InnoDB on a DRDB back-end. There's alot of stuff that's different between MyISAM and InnoDB, but the DRBD thing is the same.<br>
<br>
What you say about backups is correct, but this hasn't anything to do with DRBD. DRDB will do fine, some other quick non-DRDB things:<br>
<br>
- MySQL tuning is (even more) essential with InnoDB.<br>
- InnoDB tables use (a lot) more diskspace than MyISAM, our disk usage was nearly 300% of MyISAM's usage for the same dataset.<br>
- If you want performance, you want to be able to load your dataset in memory.<br>
<br>
Kind regards,<br>
<br>
Dirk<br>
<br>
<o:p></o:p></p>
<div>
<p class="MsoNormal">Op 12-6-2013 15:44, Robinson, Eric schreef:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">We have been a MyISAM shop forever but we are considering switching to innodb. There is scant information available on using innodb with drbd. Are there special considerations and pitfalls?
I have been told that it is not possible to backup innodb by doing a simple rsync of the data directory to another server like we can do with myisam. If that is true, what does that say about using innodb with drbd, which does essentially the same thing?</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">--<br>
Eric Robinson</span><o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray">Disclaimer - June 12, 2013</span>
<span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray">This email and any files transmitted with it are confidential and intended solely for
<strong><span style="font-family:"Verdana","sans-serif"">'<a href="mailto:drbd-user@lists.linbit.com">drbd-user@lists.linbit.com</a>'</span></strong>. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views
or opinions presented in this email are solely those of the author and might not represent those of Physicians' Managed Care or Physician Select Management. Warning: Although Physicians' Managed Care or Physician Select Management has taken reasonable precautions
to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments.</span>
<br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>drbd-user mailing list<o:p></o:p></pre>
<pre><a href="mailto:drbd-user@lists.linbit.com">drbd-user@lists.linbit.com</a><o:p></o:p></pre>
<pre><a href="http://lists.linbit.com/mailman/listinfo/drbd-user">http://lists.linbit.com/mailman/listinfo/drbd-user</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">-- <br>
<a href="http://www.proactive.nl"><img border="0" width="84" height="105" id="_x0000_i1025" src="cid:image001.gif@01CE67AC.9C400440"></a><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td width="20" style="width:15.0pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial","sans-serif"">T<o:p></o:p></span></p>
</td>
<td style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial","sans-serif"">023 - 5422299<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial","sans-serif""> <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial","sans-serif""><a href="http://www.proactive.nl">www.proactive.nl</a><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial","sans-serif""> <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial","sans-serif""><a href="http://nl.linkedin.com/in/dirkbonenkamp"><img border="0" width="50" height="14" id="_x0000_i1026" src="cid:image002.gif@01CE67AC.9C400440"></a><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial","sans-serif""> <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial","sans-serif""><a href="skype:dirkbonenkamp?call"><img border="0" width="114" height="20" id="_x0000_i1027" src="cid:image003.png@01CE67AC.9C400440" alt="My status"></a><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>