LogToMysql
About LogToMysql is a set of simple programs to log Apache access and errors to a MySQL database using the piped log mechanism.
LogToMysql will work with both Apache 1 and Apache 2, or any other server which supports piped logging.
Using LogToMysql it is possible for several computers to log to a single database. Both access and error log management can be simplified in this way if you run a large cluster of machines. The database can be on the same machine as Apache, or on a separate machine.
No modification to the standard Apache install is required - no patching, no recompilation.
Written in C
Performance On an Athlon 1800 machine running both the Apache server and MySQL it was possible to sustain logging of over 200 hits per second without problems.
Licence GPL version 2.
News
4-Nov-2003 First public release, version 0.9
10-Nov-2003 Version 0.91 - documentation corrections
17-Nov-2003 Version 0.911 - documentation corrections. Note that MySQL 4.0 or above is required.
20-Sept-2005 Version 0.95 - (1) Changes to prevent segmentation fault in case attempting to log when the database is down, or is slower starting up than the Apache server. (2) Added writing errors to standard output if there is no error log configured - thanks to George Chelidze
|