Jason Schoonover
2007-04-16
Mysql Statistics Collecting

This document will explain how to enable MySQL statistic collecting for
graphing and monitoring in unnoc.

The MySQL plugin has been tested against:
	MySQL 4.0.x for Linux
	MySQL 5.0.x for Linux

This document will explain how to monitor MySQL databases in unnoc.  In
a nutshell, you must first create a read only user to connect to the
database, and then you must configure unnoc to point to the new mysql
server.

1. Create a MySQL read-only user

To enable MySQL statistic collecting, you should login to the mysql
database and create a mysql limited read-only user.  The following
example will enable SELECT access only for the user "unnoc" with the
password "test123" coming from the unnoc host, which is 10.2.3.4.

 mysql> GRANT SELECT on mysql.* to "unnoc"@"10.2.3.4" identified by "test123"


2. Unnoc Configuration

Then, in the etc/unnoc.conf file, you should tell unnoc about the new
mysql host:

	host {
		hostname = server1
		communtiy = public
		updown = ping
		plugin = mysql
		mysql_username = unnoc
		mysql_password test123
	}

At this time, only standard configuration options are supported:

	MySQL port is 3306
	MySQL SSL is not supported



vim:tw=72:wm=1