Hi,
On 01/10/2021 14:15, Ian Diddams via Xymon wrote:
we have a HA mysql db cluster that runs with a VIP (drbd, pacemaker, corosync)
we want a ports check for 3306 - but if we configure it for the two systems in the cluster one of them will always be red as its the slave and not running mysqld (it only runs on the master).
the clear alternative is to somehow run a 3306 check on the VIP...? but the VIP itself is only an IP in hosts.cfg (so we can conn check its existence etc) and so isnt a client sending reports back to the server.
any hints as to how we can acheive such a test ?
You could try a combo status test, I've implemented these for connection tests, but it should work for port checks too, I guess (have not tried it though).
(all paths are for Debian, that's what I am using)
I defined a target in /etc/xymon/combo.cfg like this:
computer.conn = (computer1.conn || computer2.conn)
This returns green if one of the machines is green and also shows both statuses in the web interface.
I guess, this should also work with ports...
Good luck! Christoph