Re: I have question regarding active/active clustering

Iter,

The answer is No (unfortunately)

Failover clustering is not like oracle RAC, an SQL Instance contains its own
databases and only runs on one of the nodes in your cluster. In case of a
failover, there will be a disconnect of connections as cluster will offline
the group (and therefore the applications/SQL) while moving the ownership to
another node in the cluster.

You cannot have 2 instances running off the same databases/disks. Failover
Clustering is a "shared nothing" cluster model.

rgds,
Edwin.




"Iter" <Iter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3E3EFAA9-84C3-40F9-83F8-7EA5CAECA99B@xxxxxxxxxxxxxxxx
Hi Guys,
I have question regarding active/active clustering. Is that this mode can
use for load balance and server redundance that means the connection keep
alive when one of node failed. Is it like oracle RAC? Thanks.



.

Relevant Pages

  • Re: 3 Node W2K3 SQL 2005 Cluster
    ... Yes, but not in the way you want, you can create another SQL instance and ... a cluster where 2 nodes can access the drive (to share sql databases) ... cluster resource group is online). ... instances have their own disks and databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Why Cluster in a test Environment?
    ... If your apps are not failover aware, ... SQL Server 2000 then takes anywhere from 30 seconds to minutes before ... a cluster but not appear in a standalone server. ... A non-clustered environment would not allow accurate stress testing do ...
    (microsoft.public.sqlserver.clustering)
  • Re: A DB with the same name om two nodes
    ... SQL Server instances failover, not databases. ... between the instances except for the cluster nodes that can potentially host ... The databases failover from one node to the other because the SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: Is there a best practise to implement a warm standby-solution
    ... Doing all this on a failover cluster is just adding complexity. ... I suspected that some of what I need is not provided by MSCS. ... ApplicationX is cluster aware. ...
    (microsoft.public.windows.server.clustering)
  • Re: Configure failover in seconds
    ... When a failover starts, it starts. ... add this script as a resource to your cluster ... Is this done in CLuster Administrator? ... before failover occurs from one node to another in Windows Server ...
    (microsoft.public.windows.server.clustering)