Where'd you get it. I've had bad experiences with generic machines but I'll take a peak if you send the link?
There are a couple of things I didn't mention 2U Form Factor with tool-less rails Redundant Power Supply Redundant Fans (any 2 fans can go) Battery Backed RAID for full commit even on abrupt power loss dual Gbit ethernet Remote Console/Power administration without Operating System 400 MHz FSB DVD-ROM All drive are hot swap Fully supported and tested on RedHat Linux ES 2.1 (no weird hardware bugs) The last one is worth 5k alone. I've had generic machines just freeze from some weird kernel incompatibility with a raid card. With 30 machines though, you can afford to lose one. For me, with 1 or 2, I cannot and must get the best. > -----Original Message----- > From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 18, 2003 2:39 PM > To: 'Adam Nelson'; 'mysql' > Subject: RE: RAID hardware suggestions/experience > > > > > -->-----Original Message----- > -->From: Adam Nelson [mailto:[EMAIL PROTECTED] > -->Sent: Tuesday, June 17, 2003 11:56 AM > -->To: 'Bernd Jagla'; 'mysql' > -->Subject: RE: RAID hardware suggestions/experience > --> > -->We recently bought a kick $%#%% machine for ~10k > --> > -->HP DL380 > -->2x2.8GHz Xeon > -->1GB RAM > -->5 15k scsi drives (2 RAID 1 for OS and logs/3 RAID 5 for data) > -->RedHat Linux Enterprise Edition 2.1 > > You overpaid by 5K > > 2 x 2.8 GHZ Xeon > 4 GB of RAM > 5 15K SCSI Drives > ICP SCSCI RAID control card with 1 Gb of ram on it. > I just bought 30 of these boxes to build out my mysql farm > for close to > 400-600 queries a second with 60 connections a second of mix read / > writes. > > > --> > --> > -->This machine easily handles 200 queries/sec and never gets a load > -->average above 1.5. For your space requirements, you may > need the HP > -->ML370 with 5 RAID 5 drives. An important thing to remember is that > the > -->raid card is very fast and the more drives (to a point) you put on > it, > -->the better, so better to have 5 smaller drives than 3 > bigger drives. > -->The reason we use raid 5 is that 95% of our queries are > selects. If > -->your ratio is smaller, you will want to consider RAID 1 or 10. > Another > -->thing I recommend is to stay with the big players (IBM,HP) and stay > away > -->from Dell which is cut rate. If you want to save money, > get a white > box > -->over dell. Also, we get it from a good salesman at cdw. > His address > is > -->[EMAIL PROTECTED] Since they are in Chicago, there is no sales tax. > -->Lastly, if you're looking to buy soon, HP small-business direct > -->(www.smb.compaq.com) is offering free shipping until June 30 (but > then > -->you have to pay tax - basically the same amount). > --> > --> > -->> -----Original Message----- > -->> From: Bernd Jagla [mailto:[EMAIL PROTECTED] > -->> Sent: Tuesday, June 17, 2003 1:15 PM > -->> To: mysql > -->> Subject: RAID hardware suggestions/experience > -->> > -->> > -->> Sorry I forgot to mention: > -->> > -->> We are using IRIS on an Origion2000, 7GB memory, 8 CPUs. I > -->> was thinking of > -->> spending up to $10K. > -->> I also wanted the redundant data for speeding up the seeks, I > -->> also need to > -->> speed up the writes. > -->> > -->> Bernd > -->> > -->> > -->> > -->> > ===================================================================== > -->> > -->> Please note that this e-mail and any files transmitted > -->> with it may be > -->> privileged, confidential, and protected from > disclosure under > -->> applicable law. If the reader of this message is not the > -->> intended > -->> recipient, or an employee or agent responsible for > -->> delivering this > -->> message to the intended recipient, you are hereby > -->> notified that any > -->> reading, dissemination, distribution, copying, or other > -->> use of this > -->> communication or any of its attachments is strictly > -->> prohibited. If > -->> you have received this communication in error, please notify > the > -->> sender immediately by replying to this message and deleting > this > -->> message, any attachments, and all copies and > backups from your > -->> computer. > -->> > -->> > --> > --> > -->-- > -->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]
