SQL Server Failover Cluster Scalable by adding nodes?

by Shellz   Last Updated February 11, 2018 04:06 AM

In the book Pro SQL Server Always On Availability Groups They write about scalability. Here is what they say "Windows Server 2012 (and above), failover clustering supports up to 64 clulster nodes. This helps to easily scale out the solution by adding nodes to it. For example, if you have a two-node failover cluster hosting applications that is getting close to hitting a node-specific capacity limit such as a CPU or memory, it is very easy to add a third node and redistribute the load." How is that possible? If you have one instance on two nodes and you need to add memory. How will another node help? You can't load balance to 3 nodes. I completely understand running two instances ( one on each node) but then adding a 3rd will provide what?

Related Questions

MSSQL Cluster Quorum corruption

Updated June 02, 2015 05:02 AM

Active/ Active SQL Server Clustering on AWS

Updated April 26, 2015 21:02 PM

SQL Server Failover Cluster on VMWare

Updated December 19, 2017 17:06 PM

Adding a new database to an existing sql cluster

Updated September 11, 2016 09:02 AM