Logging to DB

[Anton Yuzhaninov]

On 06/07/11 01:17, John Macleod wrote:
> Is there any tried and tested way to log to a database?
>
> There appears to be several options using fifo, syslog, etc floating
> around, however, there seems to be some issues with certain options.

how to do this depend on acceptable delay.

If you need nearly real time info in DB:
tail -F /var/log/access.log | /path/to/writer_logs_to_db

If several minutes lag is acceptable, you can rotate logs and then load full log 
in single transaction.

-- 
  Anton Yuzhaninov