Re: [gentoo-user] MySQL server hardware recommendation

[kashani]

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@g.o mailing list