HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Technical (http://www.howtoforge.com/forums/forumdisplay.php?f=8)
-   -   Apache Logs to MySQL (http://www.howtoforge.com/forums/showthread.php?t=17748)

Mosquito 27th November 2007 17:25

Apache Logs to MySQL
 
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 08: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 16:14

Quote:

Originally Posted by Mosquito
1.) Would ISPConfig work without changes if Apache logs were moved to the database instead of the current log files?

No.

Quote:

Originally Posted by Mosquito
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.


All times are GMT +2. The time now is 05:32.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.