MySQL Probe

Has anyone made a MySQL probe for the Dude?

do you mean to return a value stored in mysql table through snmp?

No, I needed a probe that checks if the MySQL DB is running.

So I made one :slight_smile:

Name: mysql
Type: TCP
Port: 3306
Connect Only: unchecked
First Receive, Then Send: checked
Receive: 4|8
Send: close

NOTE: Seems that MySQL v.5x sends ether 4 or 8 as a response to a connection. You might need to change the ‘Receive:’ string to match what your MySQL version first responce.

I use a simple connect only tcp probe on port 3306 - that’s how I know if the service is started or not at least.

How did you figure out to put 4 or 8 in the receive field? It does not work for me, no matter what number I put there.

Would be nice if we could do a query, to check if the db is alive.

As for the 4 and 8, I used telnet and tcpdump. It clearly returns one of those numbers. And the probe works :slight_smile: at least for my mysql versions.