Re: Help design client/server system

In <l697187.31.2CA87DBE_at_lmsc5.ssd.lmsc.lockheed.com> l697187_at_lmsc5.ssd.lmsc.lockheed.com (Scott VanArtsdalen) writes:

>Greetings,
> We are new to the client server world. We are currently migrating
>from an IMS database to Oracle 7. Our platform will be HP 9000's; 2 G30's
>and 3 G20's. The G20's are to be application servers and the G30's are
>to be database servers. My question is: how would you set this up? Should
>we set up one database that is distributed across both db servers? Should
>we run the database on one machine and have the other mirror it? Should we
>be restricting the Oracle applications to only run on the 3 app servers?
>Should we just distribute all applications and databases across all 5
>servers? What are the net's thoughts on this?
 

>Thanks in advance!

What you need is serious professional help. (Warning, I'm in the business of giving that help, but I'm much too far away to be of any use to you)

Distributed databases (even in V7) are always slower. Are you trying for full redundancy, or just the ability to recover quickly from a crash? How quickly does your data change? What's the mix of updates to queries? etc, etc?

Dave

>---------------------------------------------------------------------------
> \ /\ Aeronca Champion 7AC
> \ /__\ N3115E
>Scott \/an \rtsdalen "The Boonie Bouncer"
>PP-ASEL Internet: l697187_at_lmsc5.is.lmsc.lockheed.com

Neat airplane!

-- 
David Benua                  Internet: dbenua_at_panix.com 
	                   Compu$erve: 72630,1416