Comments

• ckotsidimos

  March 2017

  As far as I know, you can direct your query to any node that you want. Then the cluster spreads the query to all nodes. by default all nodes are active

  0
• khizer19194

  March 2017

  Thanks @ckotsidimos .

  I need to query the cluster from a remote server. So at any time, the command requires a hostname.

  Consider a scenario where the current active node goes down.
  If I hard-code the hostname of initial active node, the query will fail and it wont replace this hostname with the hostname of the new active node intelligently.

  I was hoping to find this information using a command or in a variable so that I can make my query intelligent enough to change hostnames as per the circumstances.

  0
• ckotsidimos

  March 2017 edited March 2017

  @khizer19194
  I have 2 cases for you.

  1) try to remotely run admintools on a node remotely and get the details from there
  there is a command to get the nodes

  2) Make a connection pool and get the names of hosts from that pool for your connection string. We have done this with the dev team in our company and worked.

  0