From: Michael Dykman Date: February 22 2009 6:33pm Subject: Re: Best RAID for a DB + LVM? List-Archive: http://lists.mysql.com/mysql/216416 Message-Id: <814b9a820902221033v367b5b94x625aed574fbeb18c@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit I work for a high-volume web site and we use nothing but RAID 10 on all databases which requires a minimum of 4 disks. The write penalty for raid 5 is just too high for our application. Much of that space goes unused, but we need the stripe to keep up with the I/O. - michael dykman On Sun, Feb 22, 2009 at 7:46 AM, Waynn Lue wrote: > I currently have a RAID 5 setup for our database server. Our space is > running out, so I'm looking to increase the disk space. Since I'm doing > that anyway, I decided to re-evaluate our current disk array. I was told > that RAID 5 isn't a good choice for databases since it's slower to write. > In addition, I've also been considering setting up LVM to take quick db > snapshots, after reading various links on the web (and posts to this list). > > So on to the questions! First, if that's what I eventually want to do (get > a new RAID server with LVM), do I need to do anything special to set up LVM > on the new system? Second, what is a good RAID setup for databases? RAID > 10? 0+1? Third, I have the choice of using SATA or SCSI in conjuction with > the RAID drives I choose. How much of a difference is there in using SATA > instead of SCSI, especially in light of whatever RAID I end up going with? > > Thanks for any insights, > Waynn > -- - michael dykman - mdykman@stripped - All models are wrong. Some models are useful.