Re: Fwd: oracle replication

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Fri, 11 May 2001 13:43:38 -0700
Message-ID: <F001.0030183D.20010511135127@fatcity.com>

Jared,

I'm replying to the list since I don't see Nihar's email address.

Multi-master replication would be an ideal candidate for this situation as long as there is a primary key on the table or one or more columns which can be used to simulate a PK. It's always important to implement conflict resolution, but especially in this situation where the same username could potentially be added at both sites.

One could also use triggers to do distributed DML to replicate the changes, but due to the two phase commit process this can be a significant bottleneck which doesn't scale.

/* SOAPBOX ON */ Replication is a complex feature which requires a thorough understanding of the replication architecture to implement it *successfully*. There are numerous issues to consider before implementing replication. I address some of these in my Replication Do's and Don'ts paper to help people decide to use replication only if it's the right tool for the job.

Bottom line... if you implement replication without knowing what you're doing it's only a matter of time before your luck will run out and you'll have problems. Keeping your resume up to date would be a good idea ;)

/* SOAPBOX OFF */ HTH,

Anita
- Jared Still <jkstill_at_cybcon.com> wrote:
  >
  >
  > FYI I am forwarding this to the list, so please
  > address
  > replies to the original sender.
  >
  > ---------- Forwarded Message ----------
  > Date: Fri, 11 May 2001 12:45:43 +0530
  >
  > Hi jared
  >
  > This is Nihar from india. I am having some query
  > regarding Oracle
  > Replication.
  > Basically i am having 2 diffrent server running
  > oracle 8i on solaris.One is
  > in usa and one is in india.Now the table i want to
  > replicate is users
  > database. I want to have unique username on both the
  > end. but Us users
  > database should be there on usa server and same for
  > the indian database
  > users.
  > can u just help me in deciding replication method
  > and can u pls tell me how
  > should i go bout it..?
  >
  > though i am not an oracle developer pls explain me
  > in details if u have
  > time.
  >
  >
  > thanks and regards
  >
  > - NIHAR SANGHVI
  >
  > NetMagic Solutions Pvt. Ltd.
  > 22,Nirlon Complex,Western Express Highway,
  > Goregaon (E), Mumabai 400 063
  >
  > Phone: 8723003 extn: 144
  > www.netmagicsolutions.com
  >
  >
  
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Jared Still
  > INET: jkstill_at_cybcon.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).

Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri May 11 2001 - 15:43:38 CDT