I have a systemEvents table.
Trigger will be running, so whenever a new row is added, it should fetch the details from the systemEvents table and send a details to the SNMP manager as a SNMP trap/inform.
Asked
Active
Viewed 684 times
0
-
Maybe a workqueue might help which can be invoked through a trigger – Anshul Mar 12 '15 at 08:10
-
11. http://stackoverflow.com/questions/22258126/send-mysql-alerts-by-snmp-traps – Joddy Mar 12 '15 at 10:21
-
2. http://www.masterzen.fr/software-contributions/mysql-snmp-monitor-mysql-with-snmp/ – Joddy Mar 12 '15 at 10:22
1 Answers
0
For one of your own tables, you can add functions to MySQL through its user-defined function (UDF) interface. This SO answer shows how to invoke PHP scripts through MySQL triggers (though similar should be ok for any scripts eg net-snmp ones to send traps).
EDIT: However after seeing comments from @Joddy, I realise now that it is probably the built in systemEvents table you want, i.e. it is state of whole MySQL you want, so one of tools he mentions may be simpler than UDF approach.
