From: Date: March 11 2010 11:31am Subject: Re: mysql & RAID List-Archive: http://lists.mysql.org/mysql/220906 Message-Id: <370238.46531.qm@web23608.mail.ird.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable --- On Wed, 10/3/10, John G. Heim wrote:=0A=0A> Hi,= =0A> =0A> I am working on configuring a new hardware database server.=0A> I= 'm a little confused as to what to do about disk. We have=0A> several mysql= databases but by far the 2 most active are=0A> spamassassin bayesian rules= and horde3/imp web mail. Both do=0A> a lot of updates. The bayesian rules = are added to each time=0A> a spam message comes in for any of our 200 users= . And the=0A> horde3/imp writes address book updates and preferences quite= =0A> often.=0A> =0A> I have read (and have been told) to stay away from RAI= D-5=0A> for update-intensive systems. Are there performance concerns=0A> wi= th RAID-10 as well? We will be buying from Dell (done deal=0A> for reasons = too complicated to go into) and the disks=0A> they're selling are 146 Gb. I= can get up to 8 of them in the=0A> server we're buying. I asked them about= just getting 2 big=0A> disks and going with RAID-1.=0A> =0A> My understand= ing is that with RAID-10, the system can do=0A> multiple reads and writes s= imultaneously so throughput is=0A> improved oversystems w/o RAID or with RA= ID-1. But the same=0A> logic would apply to RAID-5 only it doesn't work out= that=0A> way.=0A> =0A> I just want to make sure I'm configuring this syste= m=0A> correctly before I order it.=0A> =0A=0AAs dan already stated, the wri= te penalty of raid 5 doesn't really make it a good fit for databases, go wi= th raid 10.=0A=0ALike you for reasons beyond my control I've been stuck wit= h dell hardware, just beware of dell raid controllers. The perc6 isn't too = bad, however I still swap them out for more capable controllers. Pretty muc= h everything before the perc6 is complete junk.=0A=0A=0A