Hello all. At the moment the company I am on is using Nagios to monitor all of the servers we are using, but after careful consideration, we decided that moving to Zabbix will be to our better interest.
However I am having some problems trying to mimic some nagios checks to Zabbix.
One of these checks is about MySQL server and its replication status. Currently, Nagios is using a plugin called check_mysql which you pass some parameters like the IP, the user, and the password, i.e
From various searches I did, I saw that the most recommended way was to use UserParameters inside the Zabbix agent configuration. The downside with that is that for each Server we will have to go and configure the Agent configuration as well as the DB user.
So I was wondering if there is a way to perform the aforementioned checks using an external script, and to pass all the required arguments, so we will only have to do this one in the Zabbix Server.
Finally, one expected result will look similar to this:
However I am having some problems trying to mimic some nagios checks to Zabbix.
One of these checks is about MySQL server and its replication status. Currently, Nagios is using a plugin called check_mysql which you pass some parameters like the IP, the user, and the password, i.e
Code:
check_mysql -H 10.10.10.10 -u dbuser -p dbpass
So I was wondering if there is a way to perform the aforementioned checks using an external script, and to pass all the required arguments, so we will only have to do this one in the Zabbix Server.
Finally, one expected result will look similar to this:
Code:
Uptime: 53146241 Threads: 3 Questions: 21531293 Slow queries: 3766 Opens: 725 Flush tables: 1 Open tables: 100 Queries per second avg: 0.405|Connections=3923818c;;; Open_files=22;;; Open_tables=100;;; Qcache_free_memory=66987144;;; Qcache_hits=2680148c;;; Qcache_inserts=366321c;;; Qcache_lowmem_prunes=0c;;; Qcache_not_cached=493096c;;; Qcache_queries_in_cache=34;;; Queries=21531294c;;; Questions=10884209c;;; Table_locks_waited=0c;;; Threads_connected=2;;; Threads_running=1;;; Uptime=53146241c;;;