July 22, 2015 at 11:39 am
Hello All
I have an interesting case that I am still unable to make it work as I want
I have 4 nodes, 2 at network A, one at network B and another at network C
Each node has a stand alone sql instance
All of them belong to the same availability group
The listener has one ip for each subnet
only nodes 1 and 2 are possible owners of the cluster and those two also have the synchronous copies of the databases at the AG
My current issues is this, if the current host owner is node1 and in there I also have the primary replica, if I go in there and stop the sql instance the owner will change to node2 but the cluster host owner will remain at node1, in my perfect world I would have liked that to also switch to Node2, is what I wnat out of the ordinary? or what I am seeing is the normal behavior?
Thanks in advance
July 23, 2015 at 3:54 am
the resource possible owners are set and managed by the availability group to cluster integration. You should not touch or change these
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2015 at 4:09 am
This is normal. SQL Server AG "Cluster group" and "OS Cluster Group" are separated entities.
Think as if you have two AG groups and one of them goes down because its disk are disconnected and then fails over other nod. There is no need to fail over the other AG cause its resources are intact. In your case OS Cluster Group resources keeps online so there is no need to change ownership to node 2.
July 27, 2015 at 9:48 am
thanks to all, there was also something wrong in the configuration of the listener, that is why I was seeing a "weird" behavior
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply