Link to home
Start Free TrialLog in
Avatar of PeterErhard
PeterErhard

asked on

Active/Active Cluster Question

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

Avatar of Metehan Ozcullu
Metehan Ozcullu
Flag of Türkiye image

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.
Avatar of PeterErhard
PeterErhard

ASKER

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"?
ASKER CERTIFIED SOLUTION
Avatar of Metehan Ozcullu
Metehan Ozcullu
Flag of Türkiye image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for that, I just wondered if there was any main difference between the two that's all.