Re: Multi-Master Replication.

We use multimaster replication at 8 sites around the world - North America, Asia, Europe. It works BUT... in my opinion this is not one of Oracle's most robust products. If you go ahead with this be sure

    You have someone on staff who really, really knows replication and what to do when problems arise - they will arise.

    Your applications are bombproof in either preventing conflicts or handling them. DO NOT let the developers tell you "conflicts will never happen, our apps don't allow them".

    Your network supports the amount of data you want to move around.     You can cope with a replication setup where master sites are running different versions of Oracle - sooner or later you'll face this.

It is also a good idea to have DBAs available who can jump on rows which show up in deferror shortly after they appear, in order to keep problems from compounding. This may imply enough DBAs to handle a 24x7 or a 24x5 system.

Van

"chan01" <chandra_2000_us_at_yahoo.com> wrote in message news:480cb9d4.0211231307.167bca91_at_posting.google.com...
> Hi guys,
> I need you openions on this application design.
>
> i got 2 database on 2 different sun servers, i am using these two
> hosts/db to server one application. now i am planning to put 3rd
> server/host to server the reports for the same application. what i am
> thinking is to replicate the db objects from the 2 hosts(a,&b) on to
> host (c). so that i can use the host C as my report server as well as
> my replica for my hosts a & b.
>
> Here is my hardware conf. and db.
> Host a: Sun E3500, Oracle 8.1.6
> Host b: Sun F3800, Oracle 8.1.6
> Host c: Sun F4800, Oracle 8.1.6
>
> Through some stones on this case.
>
> Thanks.
Received on Sat Nov 23 2002 - 16:26:01 CST