Hi hi all,
After two days of hard work, I'm coming with a new template for MySQL monitoring.
the one provided on the wiki (http://www.zabbix.com/wiki/howto/mon...ng_replication
) contains too many datas, then hard to "read", I've noticed that I was barely able to understand them.
So I've decided to create a shinny new template, which get only the critical values, (54 items) and I've created a set of nice triggers and graphs.
Here is the final result :
Here are the graphs :
1- Download the template, which replaces the current Template_App_MySQL one.
2- Download the bash script (rename it to .sh) and make it executable
3- At line 22 and 23 set the correct MySQL credentials (You should create a dedicated user)
4- Put this script on a server you want to monitor
5- Cron it! (Mine is launched every 5 minutes)
How does it work
The bash script connects one
time to the MySQL server, gets all the datas, and exit
Then the values are formatted, and sent to the Zabbix Server, eg :
HOSTNAME KEY VALUE
A temporary file is generated, but deleted when the send is complete.
If you need extra values (but remember, I've tried to get only the representatives values (around 54 keys of hundreds that MySQL provides)
My triggers try to be the most representatives ones, wich "good" ratios, but I could be wrong on some triggers. When the turn to true, it mainly means that you could optimize your database.