Re: Difference between Clustering and Replication

raghu wrote:
> I am confused between clustered and replicated databases.
> What is the basic difference between them and when are they used?
>
> Thanks.

Two different concepts that bear essentially no relationship between each other.

In clustering (RAC) you have multiple instances connected simultaneously to a single database. There is a single copy of the datafiles being accessed by multiple servers (nodes).

In replication, whether with stand-alone or RAC you are replicating the data from one database (set of datafiles) to another.

Daniel Morgan
University of Washington
www.psoug.org Received on Sun May 07 2006 - 11:01:17 CDT