OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: mysql & RAID

From: John Daisley (daisleyjohngooglemail.com)
Date: Tue Mar 16 2010 - 10:37:37 CDT


What are your plans for OS as this can have an impact on hardware choice
especially if you are considering Solaris or Open Solaris.

Regards
John

On Tue, Mar 16, 2010 at 3:22 PM, Евгений Килимчук <ekilimchukgmail.com>wrote:

>
> http://assets.en.oreilly.com/1/event/27/Linux%20Filesystem%20Performance%20for%20Databases%20Presentation.pdf
>
> 2010/3/10 John G. Heim <jheimmath.wisc.edu>
>
> > Hi,
> >
> > I am working on configuring a new hardware database server. I'm a little
> > confused as to what to do about disk. We have several mysql databases but
> by
> > far the 2 most active are spamassassin bayesian rules and horde3/imp web
> > mail. Both do a lot of updates. The bayesian rules are added to each time
> a
> > spam message comes in for any of our 200 users. And the horde3/imp writes
> > address book updates and preferences quite often.
> >
> > I have read (and have been told) to stay away from RAID-5 for
> > update-intensive systems. Are there performance concerns with RAID-10 as
> > well? We will be buying from Dell (done deal for reasons too complicated
> to
> > go into) and the disks they're selling are 146 Gb. I can get up to 8 of
> them
> > in the server we're buying. I asked them about just getting 2 big disks
> and
> > going with RAID-1.
> >
> > My understanding is that with RAID-10, the system can do multiple reads
> and
> > writes simultaneously so throughput is improved oversystems w/o RAID or
> with
> > RAID-1. But the same logic would apply to RAID-5 only it doesn't work out
> > that way.
> >
> > I just want to make sure I'm configuring this system correctly before I
> > order it.
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=ekilimchukgmail.com
> >
> >
>
>
> --
> Best regards,
>
> Eugene Kilimchuk <ekilimchukgmail.com>
>