Re: What is the cost of replication?

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Wed, 16 May 2001 21:04:42 -0700
Message-ID: <F001.00305BAC.20010516203022@fatcity.com>

Ron,

Replication is not for the faint of heart and it would behoove you to research this to see if replication is really the right way to accomplish your goal.

How much time is needed to maintain a replication environment is entirely dependent on how well the environment was designed and implemented. When properly designed, a replication environment does not require that much additional maintenance. Of course, this also depends on the complexity of the environment. Obviously a hybrid environment encompassing 15 databases is going to require more maintenance than a two-database multi-master environment.

There are many issues to consider, but one issue often overlooked is change control. Replicated tables, for example, cannot be modified with standard ALTER TABLE commands so it becomes even more important to make structural changes in a controlled fashion. Want to bring a multi-master replication environment to its knees? Just alter a key replicated table to add a not null column... not a pretty sight.

HTH,

• Anita

P.S. I'm sending you my paper which discusses many of the issues you should consider before implementing replication.

• "Smith, Ron L." <rlsmith_at_kmg.com> wrote:
  > We have a small but critical application running on
  > NT. The user wants to
  > implement replication. We have never done
  > replication for Oracle. Can
  > someone give me an idea of how much difficult it is
  > to maintain a replicated
  > database on NT. How much of my time will I need to
  > allocate to keeping
  > everything working?
  >
  > Ron Smith
  > Database Administration
  > rlsmith_at_kmg.com
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Smith, Ron L.
  > INET: rlsmith_at_kmg.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 Wed May 16 2001 - 23:04:42 CDT