My understanding is that adding Query nodes increases throughput because the clients will round robin queries to the available query nodes.
I’m wondering if I can add a query node and some how exclude it from the round robin and point particular queries to it.
This is useful because we have a few very long running/heavy transactional queries that we’d like to run in isolation.
Ideally we’d like to be able to spin up and take down a isolated node as needed for these queries so that they don’t adversely impact the rest of the system.
Also, am I correct about the round robin strategy, because if so, then I don’t understand how the system prevents starvation for a given query since it’s possible that it’s been round robin’d to a long spinning query node.