SCSI isn't necessarily faster now. The big difference used to be SCSI's support for command queueing, which is why it was faster in multi-user environments. Command queueing is now fairly common in SATA drives. The highest end SCSI is probably still faster than the highest end SATA, but you will have less disk space and it will cost much more. I would recommend using one of the "RAID in a box" solution. They have big caches for the whole RAID and they are optimized to the controllers. If money isn't really an issue, you may look into something like NetApp. That would have everything you need.
Brent Baisley On Mon, Feb 23, 2009 at 6:58 AM, Andy Smith <a.sm...@ukgrid.net> wrote: > What RAID level to use, whether to use SCSI or SATA etc are all pretty much > "how long is a piece of string?" questions. If you have a really high end > hardware array RAID 5 may be faster than RAID1+0 is on a cheaper system. > > Basically > > RAID 5 = slower > SATA = slower > RAID 1+0 = faster > SCSI = faster > more physical disks = faster > more expensive controller = faster > > ;) > > If you want to compare specific hardware you'll need to get your hands on it > or find someone else who has already done a comparison. But it will make a > huge difference to performance what disk array you have hooked up, just > depends how much you want to spend.... > > Quoting Waynn Lue <waynn...@gmail.com>: > >> 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 >> > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=brentt...@gmail.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
