Search code examples
zabbix

Can Zabbix to monitor parameter from MySQL base?

Is there a way to monitor some data from MySQL for Zabbix 3? For example, for this query:

SELECT SUM(`column1`) FROM `table` where `column2` = "text"
Solution

  • Yes, there are several ways to do that.

    • ODBC monitoring can execute such queries without any additional scripts, but requires configuring odbc.ini
    • External checks can run commands/scripts on the Zabbix server or proxy
    • Userparameters can execute commands/scripts on Zabbix agents
    • You could also have a separate script gather the data and then send it to the Zabbix server using Zabbix sender