Maximum cluster nodes in SQL AlwaysOn

Question

Maximum cluster nodes in SQL AlwaysOn

glugingboulder

SSCommitted

Points: 1832
More actions
March 17, 2014 at 1:35 pm

#396433

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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 1

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 SSCommitted Points: 1832 More actions · Answer 2

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 One Orange Chip Points: 28294 More actions · Answer 3

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 SSCommitted Points: 1832 More actions · Answer 4

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 One Orange Chip Points: 28294 More actions · Answer 5

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 SSC Guru Points: 233841 More actions · Answer 6

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" 😉