Good Day, Looking to monitor Galera cluster. Running the SQL query: SHOW STATUS LIKE 'wsrep_cluster_status'

It returns:

Variable_name Value

wsrep_cluster_status Primary

I am looking to monitor Primary but the query using MySQL sensor is only returning wsrep_cluster_status not the Value Primary. Is there a way to monitor the value Primary? Thanks.


Article Comments

Hello,

Thank you very much your KB post. I'm afraid we indeed do not have a native sensor for such a scenario. And the suggestion is to solve this with a self written script running as a custom exe sensor. Please understand that we cannot provide support in custom scripting or scripting suggestions.

best regards.


Mar, 2016 - Permalink