Hi folks,
I'm working on a full monitoring solution for MySQL, and it's about 162 variables total.
Need some advise on the mechanics of this: So far, I am gathering the info via PHP, and was going to have it calling shell("zabbix_sender $host ...").
I need some help understanding if this is the optimum scheme to send from multiple hosts (master db, 2nd master, slave, etc.).
For instance, here's various questions I'd like some help on:
What are some other things to consider? Is there a better way to do this?
TIA
Mike
I'm working on a full monitoring solution for MySQL, and it's about 162 variables total.
Need some advise on the mechanics of this: So far, I am gathering the info via PHP, and was going to have it calling shell("zabbix_sender $host ...").
I need some help understanding if this is the optimum scheme to send from multiple hosts (master db, 2nd master, slave, etc.).
For instance, here's various questions I'd like some help on:
- Do I have to pre-configure the items in Zabbix before the agent sends, or can I create the script first?
- I'm probably going to divide this into 2 or 3 different scripts, 1 that provides fast response (i.e every minute or so), and another that is once/hr or so. How would the server request this? For instance, with mysql.Connections, mysql.Aborted_connects, mysql.Aborted_clients are all provided by script 1, whereas mysql.Root_login_enabled would be by script 2. How do I relate the time for polling each? How does this relate to UserParameter in zabbix_agentd.conf?
- I'd like to mass-create the xml to import this, rather than keying in via the web. Are there docs somewhere for the format for the xml file? What are type, and value_type, for example?
- The docs say zabbix_send can take an input file. I'm pretty sure it's the latest version from ubuntu, but mine doesn't seem to have that option. Do I need to manually compile?
What are some other things to consider? Is there a better way to do this?
TIA
Mike