Brent, I'd disagree with your felling that today's disk drives are more reliable than dive years ago.
I used to think of disk failures as a rare event, but now that they are producing such high capacity parts for next to nothing, I think quality has suffered. I've heard of a lot more people suffering drive failures (in PCs, laptops and servers) recently. Also, I believe that Fujitsu produced an enormous batch of disks which had a very high failure rate. Whatever, I'd say make sure you've always got hot standby disks in your raid arrays, and keep decent backups :-) Andy > -----Original Message----- > From: Brent Baisley [mailto:[EMAIL PROTECTED] > Sent: 12 May 2005 17:47 > To: Scott M. Grim > Cc: mysql@lists.mysql.com > Subject: Re: SATA vs SCSI > > I'd be curious what you tested. Did the SATA drives support tagged > command queueing (TCQ)? That can make a huge difference in a multi-user > environment, detrimental in a single user. How many drives were in the > SATA array and how many were in the SCSI array? You could probably put > 2-3x the numbers of drives in the SATA array, boosting performance, for > the same price as a much smaller SCSI array. One on one I think an SATA > is slower than SCSI, but bang for the buck I think goes to SATA. > Here's a link to a review comparing SATA and SCSI. It shows equal > setups (meaning number of drives) of SCSI and SATA have similar > performance, but the SATA setup costs 40% less. Reliability is of > course a major consideration, but the SATA drives of today are probably > just as reliable as SCSI drives of 5 years ago. Kind of like the worst > cars of today are more reliable than the best cars of 10 years ago. > > http://www.storagereview.com/articles/200406/20040625TCQ_1.html > > > On May 12, 2005, at 11:42 AM, Scott M. Grim wrote: > > > I've fairly extensively (although not necessarily scientifically) > > tested > > SATA 150 vs. SCSI U320 and find that if you're doing a lot of random > > reads > > and writes (such as with a database server), SCSI provides nearly 5x > > the > > performance as SATA so, for us, it's well worth the additional expense. > > > > It's also my experience that even the best SATA drives seem to be > > disposable. There's a huge difference in reliability and life > > expectancy > > between SATA and SCSI drives because they put a bit more quality into > > SCSI > > drives as they are expected to perform in an enterprise environment. > > > > With RAID arrays and hotswap bays, it's easy enough to deal with SATA's > > unreliability, but it's always best to not have to swap and rebuild > > because > > every failure has the potential to cause some cascade that can become > > devestating. > > > > ----- Original Message ----- > > From: "Kevin Burton" <[EMAIL PROTECTED]> > > To: <mysql@lists.mysql.com> > > Sent: Wednesday, May 11, 2005 3:29 PM > > Subject: SATA vs SCSI > > > > > > Were kicking around using SATA drives in software RAID0 config. > > > > The price diff is significant. You can also get SATA drives in 10k RPM > > form now., > > > > Kevin > > > > -- > > > > > > Use Rojo (RSS/Atom aggregator)! - visit http://rojo.com. > > See irc.freenode.net #rojo if you want to chat. > > > > Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html > > > > Kevin A. Burton, Location - San Francisco, CA > > AIM/YIM - sfburtonator, Web - http://peerfear.org/ > > GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412 > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > Brent Baisley > Systems Architect > Landover Associates, Inc. > Search & Advisory Services for Advanced Technology Environments > p: 212.759.6400/800.759.0577 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]