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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for that, I just wondered if there was any main difference between the two that's all.
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.