🚀 go-pugleaf

In be.comp.hardware Louis <nospam@nospam.nl> wrote:
> Hi,

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

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

A Linux Dual xeon system will outperform your F50 by a factor 10
(estimated guess). Get a decent dual Xeon from Dell, with 2 or 4 GB ram
in it. If you can manage it with 4 or less GB of ram, keep it under that
limit... Linux has support for more, but it's not as optimal. Grab a
3Ware 12 disk card. It's a RAID card, your OS sees it as a scsi device,
but you can attach 12 hot swap IDE disks to it (12 x 160 GB or 12 x 200
GB? Is that enough?) Configure the disks in RAID 5, or even RAID 0+1.

For the price of such a system with IBM or Sun, you could even afford 3
of these!


Kind Regards,
Frank Louwers

-- 
Openminds bvba                www.openminds.be
Tweebruggenstraat 16  -  9000 Gent  -  Belgium

Louis wrote:

> Hi,
> 
> 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.
> 
> 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.
> 
> Please advise.
> 
> Regards,

I'd go with a dual Opteron, depending on Basis's willingness to compile
their software for it.

If you're used to AIX with its logical volume manager and disk mirroring, then you may want to install the logical volume manager available for Linux. I've never used it under Linux so I don't know if it supports mirrored disks the way AIX does. A raid controller that supports mirrored disks and hot swapable devices may be the way to go.

Randy

On Wed, 11 Jun 2003 20:36:21 +0200
"Louis" <nospam@nospam.nl> wrote:

> Hi,
> 
> 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.
> 
> 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.
> 
> Please advise.
> 
> Regards,
> 
> 


-- 
Reply to: rwcooper@mts.net (mail checked week nights and weekends)

Frank

Thanks for your reply. Does Linux address each CPU separately, or does the
server act as it has one CPU ? Maybe this is a stupid question, but I am not
a hardware/OS specialist.

I am also having another question, we want to run 2 servers. Is it possible
that both servers access the same disk set / raid. We want to be very
flexible with both servers accessing the same database or be able to switch
the database quickly. NFS doesn't seem to be the good solution, our DBMS
supplier says that we shouldn't store a database on an NFS filesystem. Are
there other methods ?

Thanks,

Louis Banens


<frank@openminds.be> wrote in message
news:bc7vog$g7uuv$2@ID-103399.news.dfncis.de...
> In be.comp.hardware Louis <nospam@nospam.nl> wrote:
> > Hi,
>
> > 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.
>
> > 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.
>
> A Linux Dual xeon system will outperform your F50 by a factor 10
> (estimated guess). Get a decent dual Xeon from Dell, with 2 or 4 GB ram
> in it. If you can manage it with 4 or less GB of ram, keep it under that
> limit... Linux has support for more, but it's not as optimal. Grab a
> 3Ware 12 disk card. It's a RAID card, your OS sees it as a scsi device,
> but you can attach 12 hot swap IDE disks to it (12 x 160 GB or 12 x 200
> GB? Is that enough?) Configure the disks in RAID 5, or even RAID 0+1.
>
> For the price of such a system with IBM or Sun, you could even afford 3
> of these!
>
>
> Kind Regards,
> Frank Louwers
>
> --
> Openminds bvba                www.openminds.be
> Tweebruggenstraat 16  -  9000 Gent  -  Belgium

You could be accused of trolling just for mentioning AIX! :)


"Louis" <nospam@nospam.nl> wrote in message
news:3ee775e7$0$49105$e4fe514c@news.xs4all.nl...
> Hi,
>
> 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.
>
> 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.
>
> Please advise.
>
> Regards,
>
>