Re: Hardware question for a DB server

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
>>
>>
>
>