How to disable Large Cluster mode for production environment?
Hi.
We have a production cluster of 10 nodes.
It was erroneously configured as a Large Cluster at the beginning, when it had only 3 nodes.
Now it has 4 control nodes (with a spread enabled), 4 racks of nodes.
We encountered some problems with our cluster, solved them with great help of Vertica support team. Members of Vertica support team pointed that it's useless to have Large Cluster for 10 nodes.
Now we plan to somehow disable Large Cluster. We plan to use following steps:
0. stop all ETL processes, disable all external connections to database.
1. SELECT SET_CONTROL_SET_SIZE(10); -- to make all nodes a control one.
2. SELECT REALIGN_CONTROL_NODES();
3. SELECT RELOAD_SPREAD(true);
4. restart cluster
5. SELECT REBALANCE_CLUSTER();
Is everything correct, or there are some other algorithms to disable large cluster and make all nodes control one?
PS. After disabling large cluster we plan to add 5 more nodes, to create a 15 nodes cluster. We want to make them all a control nodes. Is it reasonable?
We have a production cluster of 10 nodes.
It was erroneously configured as a Large Cluster at the beginning, when it had only 3 nodes.
Now it has 4 control nodes (with a spread enabled), 4 racks of nodes.
We encountered some problems with our cluster, solved them with great help of Vertica support team. Members of Vertica support team pointed that it's useless to have Large Cluster for 10 nodes.
Now we plan to somehow disable Large Cluster. We plan to use following steps:
0. stop all ETL processes, disable all external connections to database.
1. SELECT SET_CONTROL_SET_SIZE(10); -- to make all nodes a control one.
2. SELECT REALIGN_CONTROL_NODES();
3. SELECT RELOAD_SPREAD(true);
4. restart cluster
5. SELECT REBALANCE_CLUSTER();
Is everything correct, or there are some other algorithms to disable large cluster and make all nodes control one?
PS. After disabling large cluster we plan to add 5 more nodes, to create a 15 nodes cluster. We want to make them all a control nodes. Is it reasonable?
0
Comments
What version of Vertica are you currently running?
Thanks,
Rory
We are running version 7.1.1-3, we are planning to upgrade it using newest available patch.
Thanks,
Nikolay
I would set the control set size up to 60. If you leave it at 10, when you add your 11th node it won't be a control node. It's perfectly acceptable to have it larger than the number of nodes - I think the default value is 120, which is when spread scalability begins to impact you.