Active/Active Cluster Question

PeterErhard
PeterErhard used Ask the Experts™
on
Is this the correct process for installing an Active/Active Cluster?

Node1

1) New SQL Server Faileover Cluster Installation
4) Add node to a SQL Server Faileover Cluster

Node2

2) Add node to a SQL Server Faileover Cluster
3) New SQL Server Faileover Cluster Installation

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Metehan OzculluSQL Service Manager

Commented:
SQL Clustering do not work active active by design. You cann have an active active cluster by installing 2 different instances of SQL. to be able to do that:
1. New SQL Server Intallation on NodeA with instance name x
2. Add nodeB to SQL Server installation with instance name x
3. New SQL Server installation on NodeA with instance name y
4. Add NodeB to SQL Server installation with instance name y.

One of the instance can be default instance instead of x or y but the second instance should be named instance.

After the setup is dinished you can move one instance to nodeB and leave one instance on nodeA. also you can set preferred nodes for them.

With this configuration you will have both instances running SQL but with completely indepedent SQL Instances.

Author

Commented:
Wouldn't point 3 be on NodeB rather than on NodeA, so my version of events or doesn't it matter in terms of where you do a "New SQL Server Faileover Cluster Installation" and where you do a "Add node to a SQL Server Faileover Cluster"?
SQL Service Manager
Commented:
it does not matter where you run new sql server failover cluster installation or add node to cluster. on point 3 it will surely be possible on node b. in that cse on point 4 you have to add node A. After finishing the installations you can decide on which node you will run each cluster instance.

Author

Commented:
Thanks for that, I just wondered if there was any main difference between the two that's all.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial