Re: Advanced Replication

A good book I found when I first started with Adv replication was Oracle Distributed Systems - O'Reilly & Associates

It's probably getting a bit dated now with the new replication GUIs in 8i and 9i - but the basics still apply and you will eventually need to probably do some programming of the replication environment at the API level to setup some simple operator commands, schema upgrades when you run upgrade as you'll want this stuff "scripted" to reduce operator errors.

Don't build it yourself using triggers unless you have some very simple replication requirements - I would say.

In terms of performance - Oracle has a tech paper (don't have the reference handy, but I think you can get to it on OTN (can't quickly find it now) - but again its a benchmark evaluation - so its hard to compare with live applications.

I believe I have a softcopy (PDF) somewhere on my drive - if you don't find it on OTN.

Have fun...

"Van Messner" <vmessner_at_bestweb.net> wrote in message news:ttp6ra7mflu335_at_corp.supernews.com...
> It works but you have to be very conservative with it. As one
example,
> you should be able to add twenty new tables to a master group, add
> replication support and have everything proceed just fine. But our
> experience is the only completely sure way to get everything to work just
> fine is to do the tables one at a time. And so on, and so on.
> A good way to start might be to set up multimaster replication on just
> two sites with just a few tables and get everything working. Then perhaps
> add in your method of conflict resolution, if you're going to use one.
Then
> add a few more tables and a third master site. Check everything
completely
> at each step. Plan for what you'll do when a site goes down or someone
> makes an error or someone adds 100,000 new rows to a table instead of the
> 100 they meant to add.
> In terms of web sites and/or books there's not really a whole lot out
> there. The Oracle documentation is about the best thing you can find.
> Oracle also offers a five-day course for $2500 which gets you up and going
> with the basics. They supply some course manuals, but they're not
complete
> and they're not indexed.
>
> Good luck.
>
>
> "Jim Kennedy" <kennedy-family_at_home.com> wrote in message
> news:oXVC7.8890$ib.3136689_at_news1.sttln1.wa.home.com...
> > I would use what Oracle built. To attempt to build it yourself is
trying
> to
> > reinvent the wheel. Do you really have the engineering, QA resources,
> > time and experience to do this task yourself? My guess would be no.
> >
> > Jim
> > "SM" <smanduk_at_profidata.com.pl> wrote in message
> > news:9rgvdi$hcd$1_at_news.tpi.pl...
> > > Hi
> > >
> > > I'm interested in your opinions about Oracle Advanced Replication
option
> > and
> > > its possibility to handle Master-Master replication.
> > > Is it reliable or should I rather consider to build my own replication
> > > procedures?
> > > Can you recommend any good web sites or books?
> > >
> > > Oracle 8.1.7 EE
> > > Windows NT
> > >
> > > I will appreciate any suggestion and tips.
> > >
> > > TIA
> > >
> > > Simon
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Mon Oct 29 2001 - 01:19:09 CST