Frank Pikelner wrote:
I wanted to ask if anyone on the list is running a large MySQL database
and for their server hardware recommendations. The servers are
anticipated to have a DB of 10-20GB, with about 5000-10000 clients
(automated). The database will be mostly used for updates to the data
making up most of the operations. We are considering using Dual AMD
Opteron processors and at a minimum of about 4GB memory (PC2700 or
PC3200 - not sure if the extra bandwidth will add much performace). One
of the items I'm debating is the type of RAID controller to use that is
well supported under Gentoo. I'm also contemplating whether to consider
a SATA2 or a SCSI subsystem.
Just as a side not, I've always wondered the type of hardware used by
Google as they have been very successful in using smaller inexpensive
boxes according to the rumors that have circulated on the Internet.
Any vendor recommendations would also be welcome.
I've been looking at a couple of the HP DL385 for a similar
application. It's fairly cost effective to toss 8 x 1GB sticks of RAM in
it though I think you can push them up to 32GB if you're willing to pay
for denser RAM. I'm still not certain what I plan to do for disk. Six
15k 36GB drive in RAID 10 would be fastest, but I think 3 or 4 disks in
RAID 5 will probably be what I go with.
HP offers the single core and dual core chips in that platform. I'm
thinking of sticking with the single core for the time being. Prices are
supposed to drop again on AMD chips next month so it might be worth your
time to wait a bit.
I've got a DL360 with a cpq smartarray raid card running Gentoo. It
works fine though the naming is a bit strange when you set it up. You
might want to check which card revision they're currently installing,
but I've had good luck with the smartarray cards and Linux over the years.
kashani
--
gentoo-user@gentoo.org mailing list