Re: Replication

Aric,
We need more info before a solutions can be proposed.

1. How complex is your schema?
2. What kind of data are you talking about? 1GB? 100GB?
3. Are you replicating the whole schema or just a subset of the tables?
4. Do all sites have the ability to update the replicated data, or is it one site being the master, the rest being read only?
5. Do you need to have data consistency all the time? (i.e. once an update is made to a record, does the change have to be made to all the sites or can it be scheduled overnight?) Or can you live with synchronizing your databases once everynight?

This stuff can be very complicated. You just can't say that replication would multiple comm. costs by 10x. It depends on the technique you're using. But 10x is way too much.
-Duc

Aric Rosenbaum wrote:
>
> We are currently planning an Oracle installation and are thinking about
> using replication. We have six offices around the world connected via
> X.25 (now) and Frame Relay (future).
>
> I have been warned off of replication due to the communications
> overhead. One integrator told me I would multiply my comm. costs by
> 10x. Also, comm. in some of our locations is less than reliable. Heck,
> its a feat if we get electricity for a whole day.
>
> Does anyone have some insight? Does Oracle replication require a
> full-time connection?
>
> Workarounds?
>
> Thanks in advance.
>
> -- Aric
Received on Thu Feb 13 1997 - 00:00:00 CST