Interested to Buy Any Domain ? << Click Here >> for more details...
Explain Active/Active and Active/Passive cluster
configurations
- 2 Answers
- 15969 Views
- I also Faced
- E-Mail Answers
Answer Posted / ali
Saji, you answer is ok, but there are some things that need
to be cleared here. Node = Windows Server, Instance = SQL
Server Installation
1.I find that more people use the terms Active/Active and
Active/Passive to detail what the cluster is actually doing
(rather than single instance or multi-instance).
2.An active/passive cluster can have two instances of sql
server running on the active node and the passive node being
idle waiting for a failover to happen.
3.Also, it is not required that in an active/active cluster
one node has default instance and the other node has named
instance, where infact both nodes can have named instances
as part of the virtual server.
ACTIVE/ACTIVE Cluster:
Active/Active clusters is really a mutli-instance (in terms
of SQL Server) cluster with each node owning a running
instance with resources leading to both nodes Actively
running business logic. Both nodes can be possible owners of
each others resources should a failover occur
ACTIVE/PASSIVE Cluster:
Active/Passive clusters is normally single instance of SQL
Server (although I have come across a few cases of
multi-instance) that runs on one node Actively and the other
node does nothing but sit and wait for a failover to occur
(passive node).
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is a user-defined function in the sql server and what is its advantage?
What is the maximum number of index per table?
Explain Reporting Life Cycle?
mention different types of relationships in the dbms?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What are page splits? : SQL Server Architecture
How to read data in a table with "select" statements?
How the authentication mode can be changed?
What are the 3 types of schema?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What does REVERT do in SQL Server 2005?
What is field in algebra?
How do I completely remove sql server instance?
How can you append an identity column to a temporary table?
What are out-of-range errors with date and time literals?
