Re: OPS or replication ?

Oren Nakdimon wrote:
>
> Hi.
> I have NT-cluster with 2 nodes.
> Data should be inserted and retrieved by clients.
> Every client makes a connection to one node and insert data, and should
> see data inserted by other clients (includes clients that were connected
> to the second node) even when the second node is down.
>
> I see two options I can use:
> 1) Oracle Parallel Server - one database with two instances.
> 2) An Oracle database and instance on each node, with replication
> between them. When both nodes are up the replication should be
> synchronous.
>
> Are there another solutions ?
> What are the pros and cons in each solution ?
>
> Any thoughts, ideas and answers will be very appreciated.
> Thanks, Oren.
>
> ====================================================
> Oren Nakdimon
> Golden Screens Ltd.
> address: 17 Abba-Hillel st., Ramat-Gan 52522, ISRAEL
> email: oren_at_gsit.co.il
> tel: +972-3-7510836
> fax: +972-3-7518221
> ====================================================

Shalom,

It depends on what kind of network your 2 nodes are. If it's a Lan then the parallel server is the best( if it's available for NT).
If it's a Wan then replication should be the best. Received on Wed Sep 03 1997 - 00:00:00 CDT