We want to remove some nodes from our cluster. Going through the docs i have understood the process such as follow-
A)Remove node from Database.
B)Remove node from the Cluster.
C)Rebalancing after node removal.
However I need some clarity on the following point mentioned in the doc
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/ManageNodes/RemovingNodesFromADatabase.htm
"When warned that you must redesign your database and create projections that exclude the hosts you going to drop, select Yes"
Our most of the projections are segmented on all nodes,what type of challenges we will face in aspects of projection redesigning.
Question
Vertica Remove Nodes?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Anyway, no, a rebalance won't help as there is skew in your data. Take a look at the segmentation clauses of the projections.