Vertica - removing nodes from a database
Here, the P6 states
- When warned that you must redesign your database and create projections that exclude the hosts you are going to drop, select Yes.
What does this actually mean. Does it mean, that I need to manually achieve this somehow (if, so, then how?), or will the admintools takes care this automatically..?
My point is, whenever I had 3 nodes, with k-safe 2, and I want to remove single node from database, then first I set k-safe to 0, then remove single node and then these remaining nodes need to recreate/refresh their projections so that instead of "segments spread across 3 nodes", these segments need to be spread across 2 remaining nodes. So that I have 2 segments instead of 3. --> How do I achieve that..?