Hi All i want to know when the node name of SQL Server clustering is created? especially for active/active cluster? there are two node names on the list when intalling active/active clustering. i guess windows admin creates them. when or how are they created? anyone has this information? thanks,
A node in MSCS is the physical machine, the name you see for the 'node' is the physical machine name. So, it's created when the admin builds and installs the box/os initially.
thanks for your reply. i know the name for node 1. how about the second node? it should be machine_namesecond-instance_name on active/active clustering, right?
I think you might be confusing "Node" with "Instance"... In an active/active cluster you have a default instance (what you're referring to as node1) and a secondary "named" instance (what you're referring to as node2). Yes, you are correct in that your second instance needs to be Machine_Namesecond-instance name, but your terms are off a bit. Generally a node is considered to be one of the physical machines that form a cluster. The SQL Server on a cluster is referred to as a "Cluster Resource" and represented by the cluster as a Virtual Name/IP address. I generally refer to a two node cluster as such: MachineA = Node 1 MachineB = Node 2 ClusterName (CL_Foo) = Cluster VIP (virtual interface). This is the cluster service interface and represents the cluster itself. SQLServer (CL_SQLFoo) = SQL Server VIP (virtual interface). This is the SQL service the applications connect to for db access and represents itself as a resource of the cluster..
thanks, Haywood yes, i'm still confused with how the second node on active/active cluster comes from. i did active/passive clustering. it's exactly like what you said. MachineA = Node 1 MachineB = Node 2 i read the book for active/active clustering. it says on "Cluster Definiction screen" that "you will need to specify which nodes SQL Server will be installed on". (link: http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering_3.asp?Tab=3 ) so i want to know the second node name on active/active clustering (only one physical machine exists on active/active clustering) comes from? by the way, have you installed the active/active clustering? i really appreciated with your reply. thanks again, --Long
You have two physical servers. Their names are the node names. You need to select both when installing instances, doesn't matter if its active/active or active/passive. There is no use selecting only one.