MySQL Quota Daemon 0.5.01 review

MySQL Quota Daemon project is a lightweight tool for limiting database sizes

License: GPL (GNU General Public License) File size: 0K Developer: lRem

0

MySQL Quota Daemon project is a lightweight tool for limiting database sizes. As the MySQL server has no support for preventing disk from getting filled up, an external one is needed. Other solutions are often bloated or to obscure to use.

This one keeps low profile, being both nice to the system it runs on and easy to use. A basic front end for simple management and informing of any quota violation is included.

How does it work:

First, you have to set up quota limits for individual databases. Then, whenever any of these limits is violated, the CREATE and INSERT privileges are taken from that database. It can be also set up to take the UPDATE privilege. When the database has been trimmed to fit the limits, the privileges are automatically GRANTed back.

Requirements:
The Quota Daemon depends on:

Perl 5 with basic modules, including DBI and DBD::mysql.
MySQL 4 or higher.

Furthermore the front end depends on:

Apache and CGI or compatible.
HTML::Template Perl module.

The installer assumes it's run on some kind of UN*X system.

Installation and configuration:

The package comes with an installer. After unpacking it with tar -zxf mysql_quota.tar.gz you should run Perl install.pl and reply all the following questions. Then, assuming you put the front end directly in you root cgi-bin directory, you can administer it by your browser visiting http://yourdomain.com/cgi-bin/mysqlquota.cgi (of course substitute the domain to whatever it should be).

The daemon, at runtime, will search for it's configuration file in the path specified at install time and at: ~/.mysqlquotadrc or /etc/mysql_quota. Alternatively you can specify other file as the only parameter. Otherwise it should be started without parameters. Assuming you installed the executable with standard name at /usr/local/bin/ you can add the line:

/usr/local/bin/mysqlquotad

to your /etc/rc.d/rc.local file, or whatever it should be under your system. And voila - the daemon starts automatically at boot time.

What's New in This Release:
This new Lite version doesn't need HTML::Template.
Any bugs found in the default 0.5 release have been fixed in both branches.