Is there a way to configure Kibana to Only query a specific node for all search queries?
Some of the time what happens is, we run a HUGE "cardinality" query ( data tables viz ) where the number of buckets is too large and causing the node the go OUT OF HEAP SPACE. This affects the insertion of data from the applications as well.
Can we have a set of nodes (say 3 nodes) only for KIBANA searching?
Hence a set of nodes will be used for data insertion queries only while the other set for searching. So even if search node fails due to large queries etc. will not affect the insertions.
Any suggestions on solving the problem?