Logging to DB
citrin at citrin.ru
Tue Jun 7 15:21:20 MSD 2011
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.
More information about the nginx