Re: AIX versus SUN and Linux, best price performance ?

From: Frank van de Pol (frank_at_coil.demon.nl)
Date: 01/28/04


Date: Wed, 28 Jan 2004 22:19:58 +0100


Please don't use RAID-5 in database applications if high performance is
one of your objectives. Better use RAID-10 (combination of mirroring and
striping) at the expense of 50% diskspace for redundancy.

Looking at the number of disks I suppose scsi is the way to go.

Dell makes some pretty decent (and cheap) servers as well.

Frank.

Arlé Mooldijk wrote:
> "Louis" <nospam@nospam.nl> wrote in message
> news:3ee728e8$0$49103$e4fe514c@news.xs4all.nl...
>
>
>>We have a IBM RS6000 F50 running AIX 4.3.3 with 3 CPU's and 9 mirrored
>
> disks
>
>>and 1.5 GB internal memory. DBMS Basis 9.1 runs on it. This database can
>
> be
>
>>compared with Oracle regarding performance. However it's not
>>multi-threading.
>>
>>We are thinking of upgrading hardware. The F50 cannot handle the job
>>anymore. The Basis DBMS runs on AIX, Linux and SUN. Our database will be
>>around 60 GB and should be spreaded on multiple disks (at least 4). In
>
> total
>
>>we need at least 10 disks (20-40 GB). We need 2-4 GB memory.
>
>
> Why do you need at least 10 disks? Disks have more storage space these
> days...
>
>
>>The solution should be cheap but also reliable. So, we prefer cheap memory
>>and cheap (instead of expensive IBM SSA disks) SCSI or even IDE disks.
>
>
> Linux is cheap. If it is a serious server then I'd recommend SCSI with a
> RAID5 controller for the database storage and a mirrored disk for OS. This
> means about 5 disks minimum (3 for RAID5 and 2 for OS). HotSwap if desirable
> (but very nice and handy when you can afford it; saves you downtime when a
> disk fails). HP/Compaq is a good choice for Intel based servers. The support
> of HP is very good (personal experience).
>
> Just my opinion though...
>
> With Kind Regards,
> Arlé
>
>



Relevant Pages

  • SUMMARY: V440 small DATABASE SERVER
    ... apprehensive about how few disks you're using. ... PICK variant database, so your mileage with my "advice" may vary. ... the App is tuned to not do crazy IO (queries tuned), ... We had a small extranet server running a fairly classic "3-tier" client ...
    (SunManagers)
  • Re: If you were developing a database in Forth...
    ... For disks, the problem just shifts to the ... querying the drive's controller to get a sense of the health of the ... It doesn't look like a database issue to me. ... But I guess if you record the verification ...
    (comp.lang.forth)
  • Re: S85 not quite right !!
    ... maximum pinable=80.0% of real memory minperm=5.0% of real memory ... resources - have been due to the wrong vmtune settings. ... that the default settings are NOT good for a database.) ... The disks do not perform that much work ...
    (AIX-L)
  • Re: Server choice.
    ... You didn't say what database you're running. ... Your 'Dell only' ... Disks: SATA ... The pricing is really close. ...
    (freebsd-hackers)
  • Re: management software suggestions?
    ... if i'm incorrect please direct me to a better usenet group. ... etc) and images of his products and clients ... a thumbnail database of the disks. ... he/she can add quite a bit of info in the database. ...
    (rec.video.desktop)