<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
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>
<br>
<br>
<div class="moz-cite-prefix">Op 12-6-2013 15:44, Robinson, Eric
schreef:<br>
</div>
<blockquote
cite="mid:A444830975772149AA75636742443BF463F6353F@psm-exch02.psm.local"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19298">
<!--ppd1000037-->
<div><span class="563134013-12062013"><font face="Calibri">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?</font></span></div>
<div><span class="563134013-12062013"></span> </div>
<p style="MARGIN: 0in 0in 0pt" class="MsoNormal" align="left"><span
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt"><font
face="Calibri" size="3">--<br>
</font></span><span style="FONT-FAMILY: Tahoma; FONT-SIZE:
10pt"><font face="Calibri" size="3">Eric Robinson<br>
</font></span></p>
<div> </div>
<br>
<br>
<font color="silver"><span style="FONT-SIZE: 7.5pt; COLOR: gray;
FONT-FAMILY: Verdana"><font size="1">Disclaimer - June 12,
2013</font></span></font> <font size="1"><font
face="Verdana" color="gray"><span style="FONT-SIZE: 7.5pt;
COLOR: gray; FONT-FAMILY: Verdana">This email and any files
<font size="1">transmitted</font> with it are confidential
and intended solely for <strong>'<a class="moz-txt-link-abbreviated" href="mailto:drbd-user@lists.linbit.com">drbd-user@lists.linbit.com</a>'</strong></span></font><font
face="Verdana" color="gray"><span style="FONT-SIZE: 7.5pt;
COLOR: gray; FONT-FAMILY: Verdana">. 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></font></font>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
drbd-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:drbd-user@lists.linbit.com">drbd-user@lists.linbit.com</a>
<a class="moz-txt-link-freetext" href="http://lists.linbit.com/mailman/listinfo/drbd-user">http://lists.linbit.com/mailman/listinfo/drbd-user</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<title>ProActive Software</title>
<style type="text/css">
html, body, table {
font-family: arial, helvetica, sans-serif;
font-size: 11px;
}
a {
color: #25aae1;
text-decoration: none;
}
</style><a href="http://www.proactive.nl"><img alt=""
src="cid:part1.09090001.07050800@proactive.nl" height="105"
width="84" border="0"></a><br>
<table cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td width="20">T</td>
<td>023 - 5422299</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><a href="http://www.proactive.nl">www.proactive.nl</a></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><a
href="http://nl.linkedin.com/in/dirkbonenkamp"><img
src="cid:part4.06010105.08050307@proactive.nl"
border="0"></a></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><a href="skype:dirkbonenkamp?call"><img
src="cid:part6.01090202.04050305@proactive.nl"
style="border: none;" alt="My status" height="20"
width="114"></a></td>
</tr>
</tbody>
</table>
<br>
</div>
</body>
</html>