Re: Active\Active Shared Database.

From: Linchi Shea (linchi_shea_at_NOSPAMml.com)
Date: 04/06/04 

Date: Tue, 6 Apr 2004 00:53:50 -0400

Not possible with Microsoft Cluster Server, which follows a shared-nothing
model, meaning that the 'shared' disk is never accessed by more than one
node at any given time. 

-- 
Linchi Shea
linchi_shea@NOSPAMml.com
"Marx" <marx.subramanian@corporate.ge.com> wrote in message
news:E8E91910-8704-43C3-9947-6EE1D7298DBA@microsoft.com...
> 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: Windows 2003 Network Load Balancing Problem
    ... Sadly my servers websites were configured with specific IPs and host ... I find it very strange why the NLB driver can receive on a virtual IP ... he set his IIS website to use ALL UNASSIGNED addresses rather than ... specifically pointing it at the single virtual cluster address. ...
    (microsoft.public.windows.server.clustering)
  • Re: upgrading sql2k cluster to sql2005
    ... that databases get locked off in the current cluster and then properly ... I maintain many SQL servers as ... Who is going to track down all of the applications that need to have ...
    (microsoft.public.sqlserver.clustering)
  • Re: Load Balanced TS Servers and Unicast Flooding
    ... Remove each on of your tse servers from the cluster, ... Start adding them back to the NLB Cluster. ... > NICs. ...
    (microsoft.public.windows.terminal_services)