In short, the ability to tell our web application to only send N1QL queries to a select few nodes in our cluster.
Here’s the back-story for perspective: As our investment in N1QL grows, we have two sides of the house:
Our Production Web Apps - .NET code sending queries to the cluster to serve our Prod web application
Reporting - Some more formalized in .NET or PowerBI, and some in raw adhoc N1QL queries
Our end-goal is a “light” level of workload isolation. We don’t want to build out an entirely separate cluster, that would be overkill for this scenario. We have a four-node cluster, and occasional we hit a “Yahtzee” scenario where a Business Analyst is refreshing a large report in PowerBI really puts the screws to a query service on an individual node in the cluster.
Then for the unlucky population of users in our web app that happen to have their query from the Prod web app land on the same node, the Prod web app response times take a hit.
So it’s easy enough to point PowerBI the adhoc tools at a single query node, but is that possible on the .NET web application side?