Exclude nodes from Autoscaling
We run huge analytics, reports and queries over our analytics node. And its expected that analytics node is sometimes over immense CPU or Memory pressure.
Current behaviour: When I enable Autoscaling, all the nodes in my cluster scales up when there is heavy load.
Expected behaviour: I would like my analytics node to slow down or the query to timeout rather than scaling the entire cluster.
Therefore, I should have an option to exclude the metrics of analytics node while deciding for autoscaling.
I ran into the same issue and was fairly surprised this was the case.
Our business analysts run incredibly inefficient queries via Atlas BI Connector. Isolating them to an analytics node should not impact autoscaling for our electable nodes. A single long running query does not mean we need more resources.
Our electable nodes are used for reads/writes by users of our application. This makes sense to autoscale because it will impact the user experience.