Re: I have question regarding active/active clustering

in-line

"Iter" <Iter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DC6C50FC-DF66-4701-806A-D33B366FBE65@xxxxxxxxxxxxxxxx
I still got confused. From your explaination and that web site you gave to
me, I think active/active cluster is like RAC in oracle, that means they
can
share the resource

no

or load banlance

no

and a node can take over other node that
is failed when it is two nodes cluster.

yes

Active/passive cluster is like oracle
standby, right?

I think so, but I don't know oracle


Is active/active a real product or just a theory?

Active/Active is a configuration of failover clustering. You can run one
Virtual SQL Instance (think of an instance as a standalone server) on one
node, and run another Virtual SQL Instance on a second node. On two nodes
you are now running two SQL instances. Effectively the two instances are
exactly the same as running two seperate standalone SQL servers. The do not
share any resource, they do not load balance in anyway, each having a
different name, each having a different IP, each having there own databases.

does this explain it better to you ?
rgds,
Edwin.



Thanks.



"Edwin vMierlo" wrote:

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
    ... active / passive for SQL server for a two node cluster means you have only ... Only one node is running this SQL instance, ... For a Microsoft definition of active / passive and active / active, ...
    (microsoft.public.sqlserver.clustering)
  • Re: RAC or Large SMP...?
    ... At Oracle OpenWorld in 2005 I built a 24 node cluster on the third ... SMP and RAC. ... for just one comparable SMP ... tcross rapttech dot com dot au ...
    (comp.databases.oracle.server)
  • Re: 10gR2 is out for x86 Solaris
    ... Looks like Apple and OS X is the last one left standing at the altar eh? ... And if Apple and Oracle don't get their act together it will ... Pictures of the 5 node cluster can be seen at http://www.psoug.org. ... This is the second commercial cluster built in two weeks. ...
    (comp.databases.oracle.server)
  • Re: I have question regarding active/active clustering
    ... is failed when it is two nodes cluster. ... Active/passive cluster is like oracle ... Only one node is running this SQL instance, ... Failover clustering is not like oracle RAC, ...
    (microsoft.public.sqlserver.clustering)
Loading