help configuring a db server

William Warren hescominsoon at emmanuelcomputerconsulting.com
Thu Feb 11 11:29:14 CST 2010


On 2/11/2010 12:11 PM, Paul M. Dyer wrote:
> Actually, Dell AMD sells a 6-way CPU.   So, the CPUs can be 2-core, 4-core, 6-core, 8-core.  I am not sure, but I imagine the AMD CPUs are still at better prices than Intel.
>
> Paul
>
>
> ----- Original Message -----
> From: "Eric Rostetter"<rostetter at mail.utexas.edu>
> To: linux-poweredge at dell.com
> Sent: Wednesday, February 10, 2010 3:35:06 PM (GMT-0600) America/Chicago
> Subject: Re: help configuring a db server
>
> Quoting "John G. Heim"<jheim at math.wisc.edu>:
>
>    
>> to go) and mysql. We have databases  for spamassassin bayesian rules,
>> drupal, moodle, imp (webmail), and our own private data.  Our private data
>> is pretty small with the biggest table containing under 10,000 records. We
>> do have a table with about 4,00 PDF docs in a blob field.
>>
>> I think we can get a machine with a quad core, 32 Gb of RAM, and 300 Gb disk
>>      
> Sounds fine to me.  I recommend, when possible, a minimum of 1 CPU and 1 GB
> memory per database.  Since you mention 5 databases, that means 5 CPUs (cores)
> and 5 GB memory minimum.  Since you can't buy 5 cores, a single quad core
> would be okay (a dual quad core even better).  But your spec sounds fine
> to me.
>
>    
>> for under $6000. But I'm confused about disk. I would think disk pspeed
>> would be fairly important. How can I configure a machine with a fast disk?
>> What are my options from Dell in that regard?
>>      
> Get the fastest RAID controller you can and are comfortable with, and as many
> of the fastest disks you can afford as you can fit in the machine.
>
> Since you want to stay under $6000, using SSD or FusionIO is probably out.
> I would think (haven't verified) that you could buy 4 (or 5) 15K RPM SAS
> drives in your price range, setup as a RAID 10.  If not, try 10K RPM SAS
> drives.  If that fails, well, there is always SATA...
>
> I personally like to buy 7 drives: 2 RAID-1 for the OS, 4 RAID-10 for the
> MySQL databases, and 1 hotspare.  But, if you need to keep costs down, you
> can dump the RAID 1 and just do 5 drives (RAID 10 plus hot-spare).
>
> You'd have to spec all that one Dell's web site to see if it comes in
> under $6K.  If not, just start dropping down until you hit your mark
> (from 7 drives to 5, from 15K SAS to 10K SAS to SATA).
>
>    
Prices yes,  performance and power usage..no  AMD right now can only 
really compete on price.



More information about the Linux-PowerEdge mailing list