Re: Oracle Cluster or other technology?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 04 Dec 2004 02:38:22 +1100
Message-ID: <41b08867$0$17883$afc38c87@news.optusnet.com.au>

Pat Alessi wrote:
> Hi. I am looking for a solution to the following problem, and I am not
> sure if clustering is the way to go:
>
> I need to have database servers at various locations around the world
> with local users hitting their local database. I also need the data to
> be updated/replicated on the other servers in near real time.
>
> Can I set up a cluster across the WAN, or is there some other
> technology that I need to use?
>
> Thanks!
>
> Pat

Not clustering (i.e., Real Application Clusters, or RAC). The latencies across a WAN are liable to bring a RAC to its knees (though probably fixable with enough cash). You want to be looking at some form of Replication -multi-master, Streams, possibly Data Guard, maybe just a standby database ...it all depends on your precise needs and the size of your wallet.

But to start with, why not visit http://tahiti.oracle.com, and search the 10g documentation for the word Replication and see what you get. Read around the topic, and you'll have a better idea of the range of solutions out there.

Regards
HJR Received on Fri Dec 03 2004 - 09:38:22 CST