How can we scale out and in Vertica cluster in Eon mode automatically?

There are some initial ideas floating around about this on Confluence here confluence.verticacorp.com:8080/display/PM/Automatic+Scaling+of+Eon+Cluster.

The short answer is that it is possible with Auto Scaling Groups in AWS. This can be programmatically done by adding/removing nodes using admintools. https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/AdminTools/WritingAdministrationToolsScripts.htm However, since it takes so long to scale up/down Vertica nodes on EON (20-30 minutes potentially), a reactive approach (scale up rapidly in respond to a workload increase) is probably not the best approach. A proactive approach would work better, meaning you scale up or down ahead of a planned workload change (like scaling up for business hours and down at night).

The other current limitation of EON is that scaling up or down will allow you to increase query concurrency since you're introducing more execution groups. This does not necessarily mean you will increase the performance of the cluster for individual queries. This is because the shard count needs to remain constant in current versions of EON.

Thanks a lot for your valuable comment on this!
I assume that there is no actual use case regarding Auto Scaling Groups in AWS with Eon yet however it would be a good option.

Regarding this end user, they want to have more nodes only every Monday. So, this would be planned as proactive. They want to add more nodes in terms of concurrency not individual performance.