I am building my Elasticsearch cluster on Azure VMs. I am thinking to enable auto scale out/in the VMs in the cluster based on the some performance throttle, such as CPU usage.
But my concern is, since the scale out/down VMs will add/remove VMs to/from cluster, it will introduce the shard re-balance which will have impact on performance.
Does anyone allow AUTO Scale on your ES nodes? Is it a good or bad idea?