I can't seem to find a monitor or component that handles mySQL. Is there something I'm missing? I'm using APM 2.5.
Hey Justin I think we can create a custom template using TCP port 3306.. Im testing now. If anyone has a better suggestion please post.
You could install the MySQL ODBC driver on the Orion server and use the ODBC Database User Experience monitor to query the MySql database.
There is a template like this in the APM 3.0 Beta. If you sign up for the beta you can try it out. I think that template might even work on a 2.5 install (I haven't tried this though).
Beta Sign up Post:
MLM: I debated using port monitoring, but there are two firewalls between the two boxes, so I'd rather not unless I have to.
Josh: Thanks for the heads up. I don't currently have a test bed set up right now, so I'd rather avoid a beta version. It occured to me in the mean time that I could set up a page on the server to do a simple SQL query and test for a response using an HTTP monitor. Does that sound feasible?
It occured to me in the mean time that I could set up a page on the server to do a simple SQL query and test for a response using an HTTP monitor. Does that sound feasible?
Sure that would work. To be clear, the ODBC Database Monitor is part of APM 2.5. We just didn't ship a default MySQL template. You can create a component monitor of this type and execute the queries from there rather than having the web page do it for you.
When you say "execute the queries from there", do you mean from the SW machine? If so, that still runs into the firewall issue, and not wanting to set the SQL server to respond outside of localhost.
