From: | Pascal Cohen <pcohen(at)wimba(dot)com> |
---|---|
To: | |
Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Hardware question for a DB server |
Date: | 2008-03-12 19:42:57 |
Message-ID: | 47D83241.6080009@wimba.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Mark Lewis wrote:
> What type of usage does it need to scale for? How many concurrent
> connections? What size database? Data warehousing or OLTP-type
> workloads? Ratio of reads/writes? Do you care about losing data?
>
I expected those questions but I was sure that I would forget or ignore
some ;)
- This Database will be accessed by Web applications but also by an XMPP
server. This means that those are not complex requests but we may have a
number of high parallel requests for small results. Ideally as many
connections as possible would be nice.
- I am not sure but I would say from what I found thanks to Google is
that we are probably closer to an OLTP type workload (but I may be wrong)
- Size of the DB: a few Gb but not yet more than the 16Gb.
- It is a read mainly database (8/9 reads for 1 write) with potential
batch updates
- We cannot afford (anymore) losing data.
> One question that's likely going to be important depending on your
> answers above is whether or not you're getting a battery-backed write
> cache for that ServeRAID-8K.
>
> -- Mark Lewis
>
> On Wed, 2008-03-12 at 19:58 +0100, Pascal Cohen wrote:
>
>> Hello, we plan to buy a dedicated server to host our database.
>> Here is the proposal I was given (with a second identical server fro
>> backup using log shipping):
>> =========================
>> IBM X3650 (This is a 2U server, can hold 8 Drives)
>> 2 x QC Xeon E5450 (3.0GHz 12MB L2 1333MHz 80W)
>> 8 x 2GB RAM (16GB total)
>> 2.5" SAS Hotswap
>> ServeRAID-8K SAS Controller
>> 8 x 73GB 15K 2.5" SAS Drive
>> CD/DVD Drive
>> Remote Supervisor Adapter II Slimline
>> Redundant Power
>> 4 Year, 24x7 2hour support/warranty
>>
>> =========================
>>
>> I would like specialists advices.
>>
>> If you need additional details, please let me know.
>>
>> Thanks in advance for your help
>>
>> Thank you
>>
>> Pascal
>>
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2008-03-12 20:08:41 | Re: Hardware question for a DB server |
Previous Message | Mark Lewis | 2008-03-12 19:23:41 | Re: Hardware question for a DB server |