mysql monitoring

Hunter32 writes: "I guess I am not getting what you want to do. Is the MySQL server in a pool behind the LTM? If so you could use a perl script on another computer to probe the MySQL database then up iControl to mark the server up or down."

 

 

Hunter it is obvious why someone would want to do this as I am looking for the same solution. The reason is that I have tomcat running with DB backend all behind the LB and currently since I am monitoring tomcat only with the LB if the DB goes down the the LB thinks everything is still fine and does not redirect to our maintenance page but just times-out with an error message.

 

 

The correct check should not only test tomcat but test al the way through to the DB.

 

 

I have attempted to try the following http monitor:

 

SEND STRING: GET saturn/gateway/webin/https?msisdn=4089049051&shortCode=73163&message=lee32&operatorId=31002&ret_override=Simplewire&username=lee&password=esposo

 

RECEIVE STRING: 200

 

 

However this fails. What I cannot figure out is what the recieve string should be as there is no text/html response it only gives an http 200 OK response which this http monitor does not seem to recognize which is strange seeing as it is an HTTP monitor.

 

I've tried it with no response string, 200 response, 200 OK, OK, port alias, no port alias and nothing works. I've triple verified the get string is correct and works fine with jmeter and a web browser.

 

 

PLEASE HELP

 

 

Thanks,

 

--Neil Ridlinghafer

 

iLoop Mobile, Inc.

 

www.iloopmobile.com