February 25, 2015 at 7:55 am
Hi,
We are doing migration to 2014 with always on set up. Our design is configuring fail over cluster with 2 nodes. Means 1 primary availability group and 1 secondary availability group.
What is the best practice to set up quorum drive for even no of nodes
February 25, 2015 at 9:04 am
a 2 node cluster will need a witness to attain quorum. If it's a same site cluster you could use a disk witness, if it's a cross site cluster use a fileshare witness
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2015 at 12:55 pm
Thanks for the reply.
What do you mean by same site and cross site. Do you mean same datastorage?
February 26, 2015 at 12:17 am
Are the nodes on separate geographical sites or are they both located in the same location. Since youre planning to use alwayson availability groups storage shouldnt be of any concern. So, now begs the question what exactly are you planning??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 27, 2015 at 10:22 am
If you have SQL 2014 running on Windows Server 2012R2 there is something called the dynamic Quorum. When this option is enabled, the cluster dynamically manages the vote assignment to nodes, based on the state of each node. Votes are automatically removed from nodes that leave active cluster membership, and a vote is automatically assigned when a node rejoins the cluster. By default, dynamic quorum management is enabled.
February 27, 2015 at 12:37 pm
salnasi (2/27/2015)
Windows Server 2012R2 there is something called the dynamic Quorum. When this option is enabled, the cluster dynamically manages the vote assignment to nodes, based on the state of each node. Votes are automatically removed from nodes that leave active cluster membership, and a vote is automatically assigned when a node rejoins the cluster. By default, dynamic quorum management is enabled.
Note that this is only during controlled shutdowns, during sudden failures the cluster does not have time to reconfigure the votes, hence why you should always configure your quorum to suit your node count and configuration
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply