~drscream
Munin, MySQL graph
It takes some time to found out how the munin mysql plugin works. Here is an easy step by step how to:
- Create a MySQL user with a password that has NOT granted privilege.
- Edit the file: /etc/munin/plugin-conf.d/munin-node
- Put the code into the file.
- Edit the two variables [SQL_Username] and [SQL_Password]. Note that there is NO space between -p and the password.
[mysql*]
user root
group wheel
env.mysqladmin /usr/bin/mysqladmin
env.mysqlopts -u [SQL_Username] -p[SQL_Password]
Now have a cup of coffee, wait some time and chill … now you see nice MySQL graphs in Munin
Send your comment by mail.
Wed 01/07/09, 7:48 pm
I would suggest nagiosgrapher (if you use nagios :)
/