Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
How does the built-in Vertica load balancer work with sub-clusters?

How does the built-in Vertica load balancer work with sub-clusters? Will it round-robin only for the nodes within the sub-cluster?
Asked during the BDC session A Deep Dive into the Vertica Management Console Enhancements and Roadmap
@nataliaS @bhavik_gandhi
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
Load-balancing with Subclusters works very similar to load-balancing with Fault Froups. When load balance group is created using the 'WITH SUBCLUSTER ' argument, the nodes in that Subcluster will participate in the process. And yes, round-robin is the default mode, but can be changed if desired. Please note, that as with Fault Groups, you must create network addresses on the nodes in the subcluster that you want to be part of the load balance group.
Here is the example of the syntax:
Please see more in Vertica Documentation: https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/AdministratorsGuide/ManagingClientConnections/LoadBalancing/CreatingLoadBalancingGroups.htm?zoom_highlight=create load balance group