On 01/10/2021 17:39, Ian Diddams wrote:
Do you also need the connection status as well? "ports" and "conn" are two different colums, I don't think mixing them would be wise?
No - TBH not really
That's why you need the "||", it's an or, so as long as one of your two hosts is green, your overall status is green.
yes - but then presumably that emans the other host is red. And that will just spoawn reports form our monitoring team or at the very least obfuscate the page sending it red for no real reason.
It will not spawn any reports or alarm, as long as one of them is green, everything is fine. So in your case, there would be three statuses:
- overall status of this check: green if one is green
- system A red or green
- system B reg or green
There are no alarms as long as one of them is green.
The bottom line is only one server in the cluster has the port in use at any one time and we dont want a "red" simoly becasue that is actually the correct situation.
cheers
ian
It will not spawn any reports or alarm, as long as one of them is green, everything is fine. So in your case, there would be three statuses:
- overall status of this check: green if one is green
- system A red or green
- system B reg or green
There are no alarms as long as one of them is green. well having set it up, the combo test is green indeed - but the two servfers that make up the combo test are shwoing
- one green (as the port check is green as mysqld is runnoing on that system)
- one red? (as the port check is red as mysqld is runnoing on that system)
So? we do get a red showing that the monitoring team will respond to. I cant make it "clear" as there are other procs and ports being checked that do need a red if alerting.
so unfortunately it doesnt seem to be the solution - but I do appreciate the attem[pt to help :-) cheers ian
On 04/10/2021 10:25, Ian Diddams wrote:
It will not spawn any reports or alarm, as long as one of them is green, everything is fine. So in your case, there would be three statuses:
- overall status of this check: green if one is green
- system A red or green
- system B reg or green
There are no alarms as long as one of them is green.
well having set it up, the combo test is green indeed - but the two servfers that make up the combo test are shwoing
- one green (as the port check is green as mysqld is runnoing on that system)
- one red (as the port check is red as mysqld is runnoing on that system)
So? we do get a red showing that the monitoring team will respond to. I cant make it "clear" as there are other procs and ports being checked that do need a red if alerting.
Oh, I see. That is the way it should work, but I did not anticipate your team responding to the sub-status as well, sorry, my mistake, I could have worded that more clearly... :-/
so unfortunately it doesnt seem to be the solution - but I do appreciate the attem[pt to help :-)
No worries, thanks for trying!
Cheers Christoph
cheers
ian
actually, Ive possibly? found a solution.
analysis.cfg
HOST=wp-vldyn-estrela ??????? PORT "LOCAL=%([.:]3306)$" state=LISTEN min=1 color=clear TEXT=MySQL
HOST=wp-vldyn-rafeiro ??????? PORT "LOCAL=%([.:]3306)$" state=LISTEN min=1 color=clear TEXT=MySQL
and now estrela's port check shows a shite unhappy face, and rafeiro's port check shows green
and combo.cfg
mysqldHA.ports = ("wp-vldyn-estrela".ports) || ("wp-vldyn-rafeiro".ports)
which seems to do the trick? - the mysqldHA ports check shows green
intrigiingly the actual output on that combo check shows
(wp-vldyn-estrela.ports)||(wp-vldyn-rafeiro.ports) = (0-0-1)||(0-0-1) = 1 wp vldyn estrela.ports wp vldyn rafeiro.ports
i.e. its all showing clear for the individual lines which are also separated where the hostname includes a hyphen...? is that all correct ? ian
On Monday, 4 October 2021, 09:38:21 BST, Christoph Zechner <zechner at vrvis.at> wrote: On 04/10/2021 10:25, Ian Diddams wrote:
? >It will not spawn any reports or alarm, as long as one of them is green, ? >everything is fine. So in your case, there would be three statuses:
? >1) overall status of this check: green if one is green ? >2) system A red or green ? >3) system B reg or green
? >There are no alarms as long as one of them is green.
well having set it up, the combo test is green indeed - but the two servfers that make up the combo test are shwoing
- one green (as the port check is green as mysqld is runnoing on that system)
- one red (as the port check is red as mysqld is runnoing on that system)
So? we do get a red showing that the monitoring team will respond to. I cant make it "clear" as there are other procs and ports being checked that do need a red if alerting.
Oh, I see. That is the way it should work, but I did not anticipate your team responding to the sub-status as well, sorry, my mistake, I could have worded that more clearly... :-/
so unfortunately it doesnt seem to be the solution - but I do appreciate the attem[pt to help :-)
No worries, thanks for trying!
Cheers Christoph
cheers
ian
On 04/10/2021 14:15, Ian Diddams wrote:
actually, Ive possibly? found a solution.
analysis.cfg
HOST=wp-vldyn-estrela ??????? PORT "LOCAL=%([.:]3306)$" state=LISTEN min=1 color=clear TEXT=MySQL
HOST=wp-vldyn-rafeiro ??????? PORT "LOCAL=%([.:]3306)$" state=LISTEN min=1 color=clear TEXT=MySQL
and now estrela's port check shows a shite unhappy face, and rafeiro's port check shows green
and combo.cfg
mysqldHA.ports = ("wp-vldyn-estrela".ports) || ("wp-vldyn-rafeiro".ports)
which seems to do the trick? - the mysqldHA ports check shows green
intrigiingly the actual output on that combo check shows
(wp-vldyn-estrela.ports)||(wp-vldyn-rafeiro.ports) = (0-0-1)||(0-0-1) = 1 clear wp clear vldyn clear estrela.ports clear wp clear vldyn clear rafeiro.ports
i.e. its all showing clear for the individual lines which are also separated where the hostname includes a hyphen...? is that all correct ?
Interesting... I'd say this looks correct, yes.
Christoph
ian
On Monday, 4 October 2021, 09:38:21 BST, Christoph Zechner <zechner at vrvis.at> wrote:
On 04/10/2021 10:25, Ian Diddams wrote:
? >It will not spawn any reports or alarm, as long as one of them is green, ? >everything is fine. So in your case, there would be three statuses:
? >1) overall status of this check: green if one is green ? >2) system A red or green ? >3) system B reg or green
? >There are no alarms as long as one of them is green.
well having set it up, the combo test is green indeed - but the two servfers that make up the combo test are shwoing
- one green (as the port check is green as mysqld is runnoing on that system)
- one red (as the port check is red as mysqld is runnoing on that system)
So? we do get a red showing that the monitoring team will respond to. I cant make it "clear" as there are other procs and ports being checked that do need a red if alerting.
Oh, I see. That is the way it should work, but I did not anticipate your team responding to the sub-status as well, sorry, my mistake, I could have worded that more clearly... :-/
so unfortunately it doesnt seem to be the solution - but I do appreciate the attem[pt to help :-)
No worries, thanks for trying!
Cheers Christoph
cheers
ian
participants (2)
-
didds3＠yahoo.co.uk
-
zechner＠vrvis.at