The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Adding multiple nodes to existing Vertica Cluster
Nithesh
- Select Field - ✭
We need to add 20 new nodes to an existing 13 node cluster. Are there any conditions on how many new nodes we can add a time. Or can we add all the 20 nodes together without any impacts?
0
Comments
You can add 20 nodes at once without any impact. However, for the new nodes to participate in queries, you will need to rebalance the data, which could have considerable impact on system performance.
How much data is in Vertica, and what version are you running? I would recommend upgrading to latest 9.2.x version to take advantage of catalog performance improvements. It would be quicker to upgrade the existing 13 nodes before adding new nodes.
There is a lot to read and understand here.
But for the most part its a simple operation of adding the nodes and re-balancing.
https://www.vertica.com/kb/Understanding-Rebalancing-Part-1-What-Happens-During-Rebalancing/Content/BestPractices/Understanding-Rebalancing-Part-1-What-Happens-During-Rebalancing.htm
https://www.vertica.com/kb/Understanding-Rebalancing-Part-2-Optimizing-for-Rebalancing/Content/BestPractices/Understanding-Rebalancing-Part-2-Optimizing-for-Rebalancing.htm
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/ManageNodes/RebalancingDataAcrossNodes.htm
https://www.vertica.com/kb/PrepareYourClusterforRebalance/Content/BestPractices/PrepareYourClusterforRebalance.htm