PDA

View Full Version : Apache Logs to MySQL


Mosquito
27th November 2007, 18:25
I have found a couple different ways to move apache logs to MySQL. I am thinking about doing this for a variety of reasons, but before I move ahead and do this I have a couple questions -

1.) Would ISPConfig work without changes if Apache logs were moved to the database instead of the current log files?
2.) I have a dedicated database server (quiet fast) and several of the tutorials I've looked at set up a failover in case the connection to the DB fails - this way apache doesn't die without the database. Other than worrying about the database not being available, are there other issues I should consider when deciding to move to a database to store these logs?
3.) Has anyone done this, and if so what was your experience?

Ben
28th November 2007, 09:53
1.) I guess several things won't work anymore e.g. webalizer etc. and the stats stuff of ispconfig, cause it can not access the files anymore.

falko
28th November 2007, 17:14
1.) Would ISPConfig work without changes if Apache logs were moved to the database instead of the current log files?No.

2.) I have a dedicated database server (quiet fast) and several of the tutorials I've looked at set up a failover in case the connection to the DB fails - this way apache doesn't die without the database. Other than worrying about the database not being available, are there other issues I should consider when deciding to move to a database to store these logs?
3.) Has anyone done this, and if so what was your experience?
I haven't tried this, but if you have a high-traffic web site, and each request will be logged to a MySQL database, then your server's load will increase dramatically.