PLANNED MAINTENANCE

Hello, DataStax Community!

We want to make you aware of a few operational updates which will be carried out on the site. We are working hard to streamline the login process to integrate with other DataStax resources. As such, you will soon be prompted to update your password. Please note that your username will remain the same.

As we work to improve your user experience, please be aware that login to the DataStax Community will be unavailable for a few hours on:

  • Wednesday, July 15 16:00 PDT | 19:00 EDT | 20:00 BRT
  • Thursday, July 16 00:00 BST | 01:00 CEST | 04:30 IST | 07:00 CST | 09:00 AEST

For more info, check out the FAQ page. Thank you for being a valued member of our community.


question

bmvamsi.sql_192302 avatar image
bmvamsi.sql_192302 asked ·

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 characters needed characters left characters exceeded

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 characters needed characters left characters exceeded

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