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.
