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 <waynn...@gmail.com> 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
 - mdyk...@gmail.com

 - All models are wrong.  Some models are useful.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to