Re: oracle 9i replication

How many databases are being updated 1,2 ...

MM replication is OK when it works, but when it doesn't you'll want to tear your head off. You also need to design the db to handle things like conflict resolution ie the same record beng updated in two sites simultaneously.

If you have one master site that handles the updates and the others are essentially read only then materialized views are a good bet.

I've only played with streams a bit, they seem OK but are still new and could have some issues with reliability.

"ginos" <me_at_privacy.net> wrote in message news:bkpamo$46tfh$1_at_ID-203138.news.uni-berlin.de...
> On 9/22/03 6:02 PM, Daniel Morgan wrote:
>
> > Let me guess ... your database is 50MB in size has two transactions
> > totaling 10K during each 24 hour period.
> >
> > If you aren't being charged by the character ... any chance you could
> > provide enough information for someone
> > to help you. Like, for example, real-time replication or deferred
> > replication?
>
> Hi,
> the database is about 500MB in size, it will be used by dynamic web
> sites: lots of read queries, few write ones.
>
> I am looking for real-time replication (hot mirror/stand by).
>
> Thanks in advance!
>
Received on Tue Sep 23 2003 - 08:31:37 CDT