question

bmvamsi.sql_192302 avatar image
bmvamsi.sql_192302 asked Erick Ramirez edited

How do I check the status of AlwaysOn SQL without having to SSH to nodes?

we've a cassandra cluster (5 nodes in dc1 and 3 nodes in dc2), out of which there are some nodess running "alwayson-sql" process running. I'm using below command to know the status of each node

$ dse -u <username> -p <password> client-tool alwayson-sql status

i'm writing a linux shell script to automate to check for "alwayson-sql" status of all nodes in the cluster

Can you please let me know how to navigate to all nodes without doing "ssh" to the node to know the "alwayson-sql"

alwayson-sql
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

You have the option of checking the status of the AlwaysOn SQL service (AOSS) on a node by making a HTTP request to the service's web interface port.

By default, the web interface is running on port 9077. If the node's IP is 10.1.2.3, the web interface is accessible on http://10.1.2.3:9077.

Note that for this to work:

  • there must be network connectivity between the machine where your script is running and all the Analytics nodes in your cluster, and
  • the firewall must allow access to the nodes and the web interface port.

If the service is operational, the page will display RUNNING. For all other states, see Using AlwaysOn SQL service. Cheers!

Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.