Re: I have question regarding active/active clustering

active / passive for SQL server for a two node cluster means you have only
one group with an SQL instance. Only one node is running this SQL instance,
the other node is not running the SQL instance and is *standby* to take
ownership if a fail condition occurs on the node running.

active / active for SQL server for a two node cluster menas you have more
than one group with SQL instances. All nodes in your cluster run (at least)
one SQL instance. In case of a fail condition, all groups will go to the
surviving node, and this node will run all SQL instances. Therefore this
might have an impact on Performance, in such a setup you need to ensure you
scale your hardware to be able to take all resources and still have
acceptable performance.

There are many more definitions of active / passive and active /active, and
some of them are confusing, and different people give different meaning to
these terms. Probably better to talk about :
- 2 node cluster with 1 SQL instance or
- 2 node cluster with multiple SQL instances

For a Microsoft definition of active / passive and active / active, please
see :
http://technet2.microsoft.com/WindowsServer/en/library/8846a72b-0882-4a24-8eee-a768e52925281033.mspx?mfr=true
(scroll down to the question "What is active/active verses active/passive?")

HTH,
_Edwin.

"Iter" <Iter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:84780791-D41C-4482-8E59-6C799157C32C@xxxxxxxxxxxxxxxx
That means it should equivelant to standby in oracle right? also, what is
different betteen active/pasive and active/active? In active/active, does
it
use log shipping same as active/pasive? Thanks.



"Edwin vMierlo" wrote:

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: I have question regarding active/active clustering
    ... Thank you so much, edwin, your answer is very helpful. ... Virtual SQL Instance on one ... exactly the same as running two seperate standalone SQL servers. ... active / active for SQL server for a two node cluster menas you have ...
    (microsoft.public.sqlserver.clustering)
  • Re: I have question regarding active/active clustering
    ... but I don't know oracle ... Virtual SQL Instance on one ... active / active for SQL server for a two node cluster menas you have ... Failover clustering is not like oracle RAC, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Break a SQL Server 2000 Cluster
    ... So your goal is to remove the SQL instance from clustering altogether and ... Real-world stuff I run across with SQL Server: ... I need to use one of the servers and the SAS device for High ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server Erro 10061 - Server does not exist or access denied
    ... firewall to allow clients to access a SQL instance on the XP SP2 box. ... > to do some configuration before connect to the SQL Server. ...
    (microsoft.public.sqlserver.connect)
  • MSDE upgrade to SQL Server 2005
    ... I have a Software product that installed the MSDE database engine with its ... The database this software product created is a SQL Server 7.0 ... loaded successfully but never queried me for what type if instance to install ... I still only have one SQL instance running. ...
    (microsoft.public.sqlserver.msde)
Loading