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
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]