[ale] Building a Linux/Mysql Database server.

[Geoffrey Myers]

LinuxGnome wrote:
> On 05/24/2011 12:26 AM, Atlanta Geek wrote:
>> I wasnt very clear.  I actually need to define the specs for a
>> mysql database server.
>> 
>> Our current server is a Quad Core ~2GHz 4 Gig 2 15k drive (no raid)
>>  configuration. And It seems to be I/O bound on a lot of
>> operations. The database  as is goes to around 45 Gig.
>> 
>> This new server needs to be able to handle our same database
>> structure with about 600 Gig of data.  There's a lot of writing and
>> reading of data.
>> 
>> Any suggestions on hardware.  Can Mysql deal with 32 Gig or is this
>> a waste of resources because its not enough to cache.  Would we be 
>> better off looking at SSDs .
>> 
>> Any guidance would be appreciated.
>> 
> 
> If this is a product you will sell, or a system your company will
> rely on for their business, then seriously, hire an experienced and
> seasoned MySQL DBA.

<troll>
Or, better yet, use Postgresql...
</troll>

:)

-- 
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson