<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>Hi Paul,</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: arial,helvetica,sans-serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: arial,helvetica,sans-serif; background-color: transparent; font-style: normal;">I'm curious to find out from you which you use DRBD at different sites, do you mean your drbd notes are in different datacenter/location? Does it slow down the whole operation?</div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: arial,helvetica,sans-serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: arial,helvetica,sans-serif; background-color: transparent; font-style:
normal;">Regards</div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: arial,helvetica,sans-serif; background-color: transparent; font-style: normal;">Louis<br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: arial,helvetica,sans-serif; background-color: transparent; font-style: normal;"><span></span></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> Paul Walsh <Paul.Walsh@bcu.ac.uk><br> <b><span style="font-weight: bold;">To:</span></b> drbd-user@lists.linbit.com <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, June 13, 2013
8:20 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [DRBD-user] drbd+mysql+innodb<br> </font> </div> <div class="y_msg_container"><br><div id="yiv7940907577">
<div>
<br>
<div class="yiv7940907577moz-cite-prefix">On 13/06/13 05:29, Robinson, Eric
wrote:<br>
</div>
<blockquote type="cite">
<title>ProActive Software</title>
<div dir="ltr" align="left"><span class="yiv7940907577622012104-13062013"><font color="#0000ff" face="Calibri">I really appreciate
everyone's input but everyone misunderstood the question I
was really asking. It's my fault for mentioning rsync. I
fully understand the difference between how rsync works and
how drbd works. We use them both all the time. But the real
question is more high level. We have been told that even if
you stop the mysql service, you still cannot backup an
innodb database by simply copying the files from one server
to another. We have been told that the mysql service will
not start properly on the new server even if you make a 100%
exact copy of all the files from the old server. If that is
true, I don't understand how using drbd can work with innodb
tables, since it basically just makes a copy of the files to
another server. Am I asking the question right?</font></span></div>
<div> </div>
<div style="MARGIN:0in 0in 0pt;" class="yiv7940907577MsoNormal" 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></div>
<div> </div>
<br>
</blockquote>
<br>
For what it's worth, we run MySQL+InnoDB on DRBD and use
Heartbeat+Pacemaker for failover between nodes at different sites.
This supports our Moodle VLE which is an important part of our
course provision. As yet we have had no problems. We also use <b>mysqldump</b>
to back up databases.<br>
<br>
To quote from Wikipedia:<br>
<br>
"
<span style="color:rgb(0, 0, 0);font-family:sans-serif;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;
line-height:19.1875px;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255, 255, 255);display:inline;float:none;">InnoDB recovers from a crash or other unexpected
shutdown by replaying its logs"<br>
<br>
These logs, by nature of the fact they're on a DRBD device, will
be identical on both nodes, so if, say, node-A fails, node-B can
assume Primary role for the DRBD device and mysql can start up,
replaying its logs to may sure the data is up-to-date. <br>
<br>
I think whoever told you mysql would not start properly was
possibly referring to what would happen if you simply copied all
the files (with, for instance, rsync) whilst the database was
active.<br>
</span>
<pre class="yiv7940907577moz-signature">--
Paul Walsh
Head of Unix/Linux Systems Services,
Corporate ICT,
Birmingham City University,
City North Campus, Perry Barr,
BIRMINGHAM B42 2SU, UK
Tel: +44 (0)121 331 5708
Fax: +44 (0)121 356 2875
Mobile: +44 (0)7974 150 421
</pre>
</div>
</div><br>_______________________________________________<br>drbd-user mailing list<br><a ymailto="mailto:drbd-user@lists.linbit.com" href="mailto:drbd-user@lists.linbit.com">drbd-user@lists.linbit.com</a><br><a href="http://lists.linbit.com/mailman/listinfo/drbd-user" target="_blank">http://lists.linbit.com/mailman/listinfo/drbd-user</a><br><br><br></div> </div> </div> </blockquote></div> </div></body></html>