Database sampling graph in zabbix?

Question

PHP

There is a mysql database, it is necessary to periodically make a fixed selection from it (by means of zabbix or a php script and enter data into zabbix (raised on ubuntu), drawing a graph there. Then monitor the graph and when the graph reaches a certain condition (for example, exceeding some value) notify how to
correctly implement it in zabbix? example algorithm of actions, names of required functions

Answer 1

External scripts or trapper will definitely suit you .
In the first case, write a shell script that will collect data and be used in the external scripts mechanism. In the second - collect data as you like (for example, php script, as you wanted) and use zabbix sender to send data to trapper.
And don't forget to wrap it with an extra trigger for "no data". This is especially true if you decide to use a trapper.

Answer 2

Judging by the fact that "Zabbix" appears in the tags, you have it in the park.
In this monitoring system, there is a data type "ODBC monitoring" ( https://www.zabbix.com/documentation/3.0/ru/manual...
Actually, you set up monitoring, Zabbix will do the rest