Re: Oracle streams

Shareplex can handle deletes, updates, and inserts across the multiple databases fairly easily. The hardest problem I had was getting the firewall's opened up for the needed ports.

It doesn't handle everything, DDL still seems to be done manually, but DML seems to work without problems.

My setup is three 'masters' across the country (Denver, Spokane, and Reston). A change to data in any database replicates the change to the other two databases. Other configurations would allow one 'master' and multiple 'slaves', so a change made on a 'slave' is sent to the 'master' to replicate back to the other 'slaves'.

The config file is fairly easy. Just list the table in the current database, then the next database. Do that for each table you want replicated, and each machine has a similar config file. I run Windows, but it works across platforms.

-- 
-- Bill Ferguson


On 10/18/07, mkb <mkb125_at_yahoo.com> wrote:


>

>  This is something that I'm concerned about.  How stable is streams?  It

> seems to work ok in a small dev environment but my concern is how it'll

> handle production loads.  The target app does not seem to be too complicated

> and it does have well defined rules i.e. no physical deletes, primary site

> updates overrule secondary site etc.

>

> There seems to be a lot of documentation out there on streams but I have

> not seen a lot on building customized conflict handlers.  I wonder how

> Shareplex handles conflicts?

>

> --

> mohammed

>

> ------------------------------

> Boardwalk for $500? In 2007? Ha!

> Play Monopoly Here and Now<http://us.rd.yahoo.com/evt=48223/*http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow>(it's updated for today's economy) at Yahoo! Games.

>


--
http://www.freelists.org/webpage/oracle-l