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


Maximum cluster nodes in SQL AlwaysOn


Maximum cluster nodes in SQL AlwaysOn

Author
Message
glugingboulder
glugingboulder
SSC-Addicted
SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)

Group: General Forum Members
Points: 422 Visits: 482
Hi,

How many nodes can you have in a cluster with SQL 2012 alwaysOn.
I understand that availability groups are limited to 5 nodes but if you had a 10 node cluster and decided to create multiple availability groups using various nodes within the 10 nodes but never exceeding 5, is that possible?
Or is there a counter or some validation from SQL AlwaysOn that actually hard limits to a grand total of 5 nodes in a cluster?

Cheers
sqlbuddy123
sqlbuddy123
SSCertifiable
SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

Group: General Forum Members
Points: 6432 Visits: 2243
Yeah, That's the limitation imposed by the architecture of Always ON itself. So even though you have 10 nodes, each AG can have 1 Primary replica and upto 4 Secondary replicas. If you try to add a 5th secondary replica you will get an error.

--
SQLBuddy
glugingboulder
glugingboulder
SSC-Addicted
SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)

Group: General Forum Members
Points: 422 Visits: 482
Thanks for reply, i understand that part, but what if you have this example.

10 node windows cluster
Availability group 1 spans nodes 1 -5.
Availability group 2 spans nodes 5-10.

Essentially you have a massive windows cluster with pockets of availability groups defined throughout.
sqlbuddy123
sqlbuddy123
SSCertifiable
SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

Group: General Forum Members
Points: 6432 Visits: 2243
glugingboulder (3/17/2014)
Thanks for reply, i understand that part, but what if you have this example.

10 node windows cluster
Availability group 1 spans nodes 1 -5.
Availability group 2 spans nodes 5-10.

Essentially you have a massive windows cluster with pockets of availability groups defined throughout.



I didn't test it but I think that should be fine. The actual requirement is the availability replica should be part of the instances on the nodes of same WSFC.

AG1 and AG2 should have different set of databases.

--
SQLBuddy
glugingboulder
glugingboulder
SSC-Addicted
SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)

Group: General Forum Members
Points: 422 Visits: 482
Yeah i'm thinking it would be fine, haven't tested either.
I believe Vmware ESX 5.5 supports a maximum of 5 nodes in a windows cluster, that's what made me think possibly there was a limitation on total cluster size in SQL AlwaysOn.

Cheers
sqlbuddy123
sqlbuddy123
SSCertifiable
SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

Group: General Forum Members
Points: 6432 Visits: 2243
glugingboulder (3/17/2014)
Yeah i'm thinking it would be fine, haven't tested either.
I believe Vmware ESX 5.5 supports a maximum of 5 nodes in a windows cluster, that's what made me think possibly there was a limitation on total cluster size in SQL AlwaysOn.

Cheers



Yeah, Window 2008 R2 and above supports upto 5 nodes for ESX 5.5. Always ON doesn't impose the node limitation.
--
SQLBuddy
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)

Group: General Forum Members
Points: 56241 Visits: 17729
glugingboulder (3/17/2014)
Thanks for reply, i understand that part, but what if you have this example.

10 node windows cluster
Availability group 1 spans nodes 1 -5.
Availability group 2 spans nodes 5-10.

Essentially you have a massive windows cluster with pockets of availability groups defined throughout.


It's perfectly valid to have multiple AO groups, as long as each group conforms to the AlwaysOn constraints

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

"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