SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Clustering SQL 2000/2005/2008 Dependencies between Cluster Groups


SQL Server Clustering SQL 2000/2005/2008 Dependencies between Cluster Groups

Author
Message
Jamie Wormald
Jamie Wormald
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 81
Can you create dependencies between Cluster Groups. The reason I am asking or am I missing something, but If you follow microsofts instructions for clustering you can end up with some resources not failing over.

If you do as microsoft say and separate the SQL Server cluster group and it resources, disks etc on from the cluster group with the Quorum drive on, then if something fails in either group it only failsover that group. So you can end up with server1 being live, but the resoures i.e the disk for SQL server on server2.
ALZDBA
ALZDBA
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28889 Visits: 8986
Your disk definitions need to be in the same cluster group as the one you want to install your sqlserver instance on.

Create a cluster resource group that only holds the resources, needed for the cluster. (msdtc, quorum, cluster name and cluster ip address).

Create another cluster group for each sqlserver instance you want to host on the cluster. This group will start with the allocation of one or more drive.
The install process of sqlserver will then define the instances ip address, name, services (dbengine, sqlagent, ...) in the targeted resource group.
It (the install process) will also add the needed dependencies in the resource group.

Johan


Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
Jamie Wormald
Jamie Wormald
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 81
If a resource fails on one of the sql instances what will make the server failover. The way I understand it only one server if live at any one time and this server is the one with access to the quorum drive. So if another server group failsover it will move to the failover server but the group with the quorom will stay where it is.
ALZDBA
ALZDBA
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28889 Visits: 8986
Jamie Wormald (8/3/2010)
If a resource fails on one of the sql instances what will make the server failover. The way I understand it only one server if live at any one time and this server is the one with access to the quorum drive. So if another server group failsover it will move to the failover server but the group with the quorom will stay where it is.


Depending off your settings for the cluster group members failover may occur.

Each resource group can failover by itself.

You can fail over one resource group indepentent from other resource groups.

Both nodes of your cluster can have resource groups active. Off course a resource group can only be active at one node at a time.

Both nodes must be up for failover to be able to use the mechanisme.

So a passive node, is a computer that mainly functions as a heating device until the cluster service or a cluster admin moves and activates a resouce group to it.


The resource group holding the quorum, can be active on any of the nodes.
I always put the quorums resouce group at the node where i want to install an instance, for the rest I don't care where it is active.

Johan


Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
Jamie Wormald
Jamie Wormald
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 81
Thank you very much.

I think I understand the idea, as long as the resource for the application or instance are in the same cluster group then it does matter which node they are on, even if the primary cluster group with the quorom is on another node.

I have just tested this theory by failing over our uat instance and it is still serving.
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52323 Visits: 17672
Jamie Wormald (8/3/2010)
The way I understand it only one server if live at any one time and this server is the one with access to the quorum drive.

is this a Windows 2003 or 2008 cluster?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search