This plugin uses mysql to fetch the performance metrics from a mysql server.
To install it:
- Verify that your system has mysql installed: $ mysql -V
- Download the file “mysql_plugin”.
- Copy it to your agent plugins directory. F.ex. on my system in “/etc/pandora/plugins”.
- Make it executable: $ chmod +x /etc/pandora/plugins/mysql_plugin
To use it you need a mysql user, for that I create a user with only select privileges:
mysql> GRANT SELECT ON *.* to (user)@localhost identified by '(password)';
NOTE: Maybe less privileges are needed, but NEVER user the mysql root account.
Then just call it from the config file of your agent with the following line:
"module_plugin memory_plugin (user) (password)"
For more plugin options or change warning and critical levels see its code.
Depends on: mysql