Welcome to Questions - Ask OpenNMS, where you can ask questions and receive answers from other members of the community.

Monitor MySQL service availability

0 votes
145 views
I'm testing OpenNMS in a virtual machine, and I want to monitor MySQL server in another VM. I'm going to install OpenNMS at my work, and I already tested several options to monitor MySQL: a third party plugin (mysql-snmp), the HTTP collector and the JDBC collector, but the first one and the last one needs I open the port 3306 to my OpenNMS IP, and I'm not allowed to do this at my work, and my boss told me that I can't install apache in the MySQL Server VM, so I can't monitor it with HTTP.

So... is there a way to monitor JUST the availability of the MySQL service? I don't want DB stats or graphs, I need just the availability of the service.

 

Thanks in advance.
OpenNMS version
17
Java version
1.8.0_45
Operating system
Linux Debian 8
PostgreSQL version
9.4.6
asked Jun 27, 2016 by Skarela (150 points)

2 Answers

0 votes

In this case the network port of MySQL 3306 is not accessible for your monitoring. You need somehow access to the system through an agent, otherwise it can't told you if the service is available. The most defensive agent IMHO is the Net-SNMP agent. You have several possibilities: 

  • Monitor the process of MySQL with the process directive of MySQL and use the OpenNMS Host Resource Software Run Monitor
  • In case it is just security policy and your OpenNMS is not able to reach the port and other application can, extend the Net-SNMP agent with a small bash script and evaluate the output of "ss -lnpt sport = :3306". You can use the SNMP Monitor to get an alarm out of it.
answered Jun 27, 2016 by indigo (10,030 points)
0 votes

Graphs and Reports make it easy to monitor MySQL Enterprise Firewall activity and protect your MySQL servers against database specific attacks. Best Practice Advisors alert you when a potential security threat has been identified and recommend configuration changes to your Firewall and related security settings.For getting writing assistance please contact cheap essay writing service,They are providing best services for their customer in order to improve their academic performance and skills.There are large number of students widely depending cheap essay writing service in order to improve their performance.

answered Jul 24, 2016 by lauratlauer (170 points)
...