<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=utf-8">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
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.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@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 lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<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-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"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> ale-bounces@ale.org [mailto:ale-bounces@ale.org]
<b>On Behalf Of </b>Jim Kinney<br>
<b>Sent:</b> Tuesday, May 24, 2011 12:13 PM<br>
<b>To:</b> Atlanta Linux Enthusiasts<br>
<b>Subject:</b> Re: [ale] Building a Linux/Mysql Database server.<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Tue, May 24, 2011 at 10:42 AM, The Don Lachlan <<a href="http://ale-at-ale.org">ale-at-ale.org</a>@<a href="http://unpopularminds.org">unpopularminds.org</a>> wrote:<o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">On Tue, May 24, 2011 at 07:37:16AM -0400, LinuxGnome wrote:<br>
> I would go with many 15k drives for the data (for example, if you have a 500G DB, then 9x 73G drives in RAID5 will you 6~8 times the performance of one 600G drive that is IO bound). You might consider a ramdrive (i.e. FlashCache, not SDD) for writing your
logs to.<o:p></o:p></p>
</div>
<p class="MsoNormal">Do NOT use RAID5. Ever. For ANYTHING. Unless you're trying to show exactly<br>
how much it sucks in comparison to RAID10.<br>
<br>
<a href="http://www.miracleas.com/BAARF/RAID5_versus_RAID10.txt" target="_blank">http://www.miracleas.com/BAARF/RAID5_versus_RAID10.txt</a><br>
<a href="http://www.zdnet.com/blog/storage/why-raid-5-stops-working-in-2009/162" target="_blank">http://www.zdnet.com/blog/storage/why-raid-5-stops-working-in-2009/162</a><br>
<br>
If you are absolutely wedded to parity, use RAID6. But really, you should<br>
still use RAID10.<br>
<br>
<a href="http://storagemojo.com/2010/02/27/does-raid-6-stops-working-in-2019/" target="_blank">http://storagemojo.com/2010/02/27/does-raid-6-stops-working-in-2019/</a><br>
<br>
The math is already out there. In RAID5, you can only survive one disk<br>
failure - two concurrent disk failures and you're dead. RAID10 may fail<br>
after two concurrent disks failures but it can survive up to n/2 disk<br>
failures, depending which disks fail, and the odds are higher that drives in<br>
different mirrors will fail rather than in the same mirror.<br>
<br>
Then, you want to rebuild. In RAID5, you have to read from n-1 disks to<br>
rebuild, whereas RAID10 requires you to read 1 disk. As disks increase in<br>
size, the probability of a read error during a rebuild approaches 100%,<br>
which is more likely under RAID5 than RAID10 because you're reading more<br>
disks and more data. Read error == failed rebuild. Some current drives are<br>
large enough that it is a certainty in a RAID5 rebuild.<br>
<br>
Do. NOT. Use. RAID5.<o:p></o:p></p>
<div>
<p class="MsoNormal"><br>
+100<br>
<br>
RAID5 was designed for when hard drives were REALLY FREAKING EXPENSIVE. RAID5 needs to die. RAID6 needs to join it.
<br>
<br>
If you're really data paranoid, triple mirror RAID1 with RAID0 stripe for speed. Makes the rebuilds fly from a user perspective.
<br>
6-drive RAID10 SAS will saturate a single PCIe x8 bus on a read :-) So build 2 sets (12 drives) and use another card :-D<o:p></o:p></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">This does not make sense to me? 6 drives will overwrite your pipe on a PCIe X8 bus so you build two of them? How does that mitigate the issue, you now have
two 6-drive raid1 with raid0. Seems you should now have the capacity to overrun two PCIe x8 bus I/O through puts?<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">Do you mean to make a raid1 out of two drives on CTRL0 and raid0 them with a raid1 on CTRL1?<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"><o:p> </o:p></span></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<p class="MsoNormal"><span style="color:#888888"><br>
-L</span><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<br>
-- <br>
-- <br>
James P. Kinney III<br>
<br>
As long as the general population is passive, apathetic, diverted to consumerism or hatred of the vulnerable, then the powerful can do as they please, and those who survive will be left to contemplate the outcome.<br>
- <i>2011 Noam Chomsky</i><br>
<br>
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Damon Chesser<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">dchesser@acsi2000.com<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">damon@damtek.com<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1">Disclaimer: This electronic transmission and any attachments contain confidential information belonging to the sender. This information may be legally protected. The information is intended only for the use of the individual
or entity named above. If you are not the intended recipient or receive this message in error, you are hereby notified that any disclosure, copying, distribution or taking of any action in reliance on or regarding the contents of this information is strictly
prohibited. Please notify the sender immediately if you have received this information in error.<br>
<br>
www.acsi2000.com<br>
</font>
</body>
</html>