barnesco
asked on
Can the same SQL cluster instance name exist on different windows clusters
My client owns a SQL cluster named instance, and I'm building a new SQL cluster named instance on a new set of windows servers. The windows servers have different names and IP's, and SQL cluster will have a new IP as well. However, my client wants to retain the same SQL cluster name. Can I do that when both exist on the same domain?
I'm worried the same SQL cluster instance name on two different systems will have a DNS or CNO name conflict.
I'm worried the same SQL cluster instance name on two different systems will have a DNS or CNO name conflict.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Same SQL named instance on two different windows clusters on the same domain: ClusterName\SQLNamedInstan
The named instance is not restrictive.
An instance is limiting on a single node/cluster.
Do you have a multi-node setup.?
I.e. The cluster includes multiple modes in active/active setup?
The main point as was commented coolie, as long as the name of the cluster is unique, the instance of little consequence in uniqueness.
Mostimportant\lessimportan
For DNS referencing mostimportant is the DNS record pointing to the application ip, the instance is an additional parameter within the application that needs to access the SQL data.
An instance is limiting on a single node/cluster.
Do you have a multi-node setup.?
I.e. The cluster includes multiple modes in active/active setup?
The main point as was commented coolie, as long as the name of the cluster is unique, the instance of little consequence in uniqueness.
Mostimportant\lessimportan
For DNS referencing mostimportant is the DNS record pointing to the application ip, the instance is an additional parameter within the application that needs to access the SQL data.
ASKER
It's just a regular, garden variety active-passive cluster, two-node setup. Nothing complicated. So I getting the drift that Coolie is right: You cannot have the same SQL cluster name shared between two clusters on the same domain. Good idea to pointing the A record to the new name.
The A record is the name.
Do you have a multy do ain Forest?
Clustername.internal.somed
While yours is Clustername.external.anoth
I.e. I've set serves internal users, while the other clusters serves external users.
Since both are running, they are unique and are not in conflict.
Do you have a multy do ain Forest?
Clustername.internal.somed
While yours is Clustername.external.anoth
I.e. I've set serves internal users, while the other clusters serves external users.
Since both are running, they are unique and are not in conflict.
ASKER
Arnold, I see what you're getting at, but I don't have a multi-domain forest. Just one domain, and I don't want to create another forest. The question was just simply asking if I can create a SQL named instance on two different windows clusters on the same domain. I'm not looking for a work-around--just a yes or no.
named I stance for SQL has a specific meaning.
Cluster name, and application cluster name
the answer coolie provide, you can not. Have two separate clusters having the same name.
Cluster name, and application cluster name
the answer coolie provide, you can not. Have two separate clusters having the same name.
ASKER
Thanks to both you for clarifying.
Clusterone\insyance
A new clustergroup\instance is created.
The two are separate and distinct would not cause issues.