Re: I have question regarding active/active clustering

Thanks. Does Active/passive use log shipping to be implemented? Is there any
difference between them? Sorry about I have so many questions. Thanks.

"Edwin vMierlo" wrote:

in line

"Iter" <Iter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F1E612C0-8D84-4967-B113-E8690429E00D@xxxxxxxxxxxxxxxx
Thank you so much, edwin, your answer is very helpful. I have other
question
related to it. for active/active, Is it used log shipping same as
active/passive?

clustering has nothing to do with log-shipping. So think about if you have
two seperate standalone servers, and you want to do log shipping, you can.
The same goes for 2 SQL instances in a cluster, if you want to do
log-shipping you can.

Does one node take over other node resource when failed? I
unstand it is not real time, but is it fail over?

Yes, If a node fails, everything running (under cluster) on that node is
going to run on the other surviving node. so Yes, your SQL instance will run
on the other node. The surviving node is now running 2 SQL instances, but
still they are considered to be two *seperate servers*.
It is not real time, there is a period where the SQL instance which was
running on the other node is offline. This period of time can be very short,
matter of seconds, or somewhat longer, matter of minutes. The period it is
offline is influenced by how you set up your cluster group, how many
resources, how many disks, and so on, so forth.

I hope this helps,
Rgds,
Edwin.

Thanks

"Edwin vMierlo" wrote:

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
    ... 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)
  • Re: I have question regarding active/active clustering
    ... a cluster as supporting a single database. ... are operational there are two database instances running on the two servers. ... there is a period where the SQL instance which was ...
    (microsoft.public.sqlserver.clustering)
  • Re: I have question regarding active/active clustering
    ... a cluster as supporting a single database. ... are operational there are two database instances running on the two servers. ... there is a period where the SQL instance which was ... "Edwin vMierlo" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: I have question regarding active/active clustering
    ... no, a cluster is a cluster, doesn't matter if it is Active / Active or ... "Edwin vMierlo" wrote: ... there is a period where the SQL instance which was ... active / active for SQL server for a two node cluster menas you ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server Cluster and MSDTC
    ... SQL Instance 1 (clustered, primary node) ... If I don't cluster MSDTC does it mean the databases ...
    (microsoft.public.sqlserver.clustering)
Loading