[gentoo-user] MySQL server hardware recommendation

[gentoo-user] MySQL server hardware recommendation

[Frank Pikelner]

[-- Attachment #1: Type: text/plain, Size: 950 bytes --]

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.

Thank you,

Frank

[-- Attachment #2: Type: text/html, Size: 987 bytes --]

Re: [gentoo-user] MySQL server hardware recommendation

[A.G.]

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 

best results obtained on IBM x445
scalable to 16 processors and to 32G of RAM with an iteresting 3rd level 
cache and a not so expandable disk subsystem (2 SCSI bay) used in RAID0 
(data are stripped on the disks for performances and backupped on 
another system in realtime by a replicator for security)

even with two processors (quad with hypertreading) and 2G or RAM system 
is very responsive on a well engineered database of some hundreds 
millions of rows

Andrea Gagliardi

...............................................
Andrea Gagliardi
Euronia srl Stradone Porta Palio, 35 37122 Verona
Voice (+39)0459580680 Fax (+39)0459580681
andrea@euronia.it http://www.euronia.it
 

 

 --

 Email.it, the professional e-mail, gratis per te: http://www.email.it/f

 

 Sponsor:

 Libri e CD musicali nuovi con sconti dal 60 all'80%!

 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=814&d=23-11
-- 
gentoo-user@gentoo.org mailing list

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@gentoo.org mailing list

Re: [gentoo-user] MySQL server hardware recommendation

[Eric Bliss]

On Wednesday 23 November 2005 08:22 am, Frank Pikelner wrote:
> 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.
> 

Wikipedia has an article purely devoted to an examination of what Google may 
be running on...

http://en.wikipedia.org/wiki/Google_platform

-- 
Eric Bliss
systems design and integration,
CreativeCow.Net
-- 
gentoo-user@gentoo.org mailing list