Active\Active Shared Database.

From: Marx (marx.subramanian_at_corporate.ge.com)
Date: 04/05/04 

Date: Mon, 5 Apr 2004 08:26:03 -0700

Hi
    Is it possible in SQLServer to setup an Active/Active cluster between two servers and access the same database?
Like Oracle's Real Application Clusters, can this be achieved in sql may be using Federation?

On a high level, i would have two sqlservers clustered, and i would federate the database horizontally and share my data across two
servers different databases. I will have Distributed Partitioned Views which will have a Union ALL of both data and reside on both databases.
The application will be smart enough to split the users across the servers and users will hit the servers concerned depending upon where
the data is.

Is this possible or only two different application can work on an Active\Active configuration?

thanks a bunch
Marx

Relevant Pages

  • Re: I have question regarding active/active clustering
    ... With log shipping or database mirroring you have two complete copies of the ... With a cluster, two different servers are ... Clustering is usually done with both servers in the ... there is a period where the SQL instance which was ...
    (microsoft.public.sqlserver.clustering)
  • Globally separated cluster
    ... I am trying to plan a SQL Server 2005 cluster across multiple data ... Basically the database backs a load balanced ... Each site has its own set of web servers and its own ...
    (microsoft.public.sqlserver.clustering)
  • Re: Access97 to SQL
    ... Data can be placed into SQLServer (or any other database eg Oracle) whilst ... You can run any version of Access with other SQL databases, ... Why have you distributed it across TWO servers? ...
    (microsoft.public.access.conversion)
  • Re: Old Possums book of practical hosts.
    ... Would this cluster be running software from the large database ... Please note that I didn't name those servers (for some weird ...
    (alt.sysadmin.recovery)
  • Re: ActiveActive Shared Database.
    ... Not possible with Microsoft Cluster Server, which follows a shared-nothing ... federate the database horizontally and share my data across two ... > servers different databases. ...
    (microsoft.public.sqlserver.clustering)