I'm working on a webpage which is similar to the yellow pages (business directory) except localised to a small town or city...
The site is to be written in PHP, using MySQL for the database, running on an Apache2 server.
I've got them all up and running (on a WinXP machine for now) and was wondering what settings and things i would need to do to keep the database running smoothly/efficiently/securely.
Since the project is only in its infancy, i cant say much on expected server load, but we're guessing that 500-1000 hits a day to the webpage would be a realistic maximum. We can assume that each of these hits performs several (5-10?) queries to the MySQL database.
My partner mentioned that connection pooling was the way to go in order to keep the system running smooth and efficient, but I havn't been able to find anything useable to do it under php/mysql/apache - does something of the sort even exist?
Other than pooling, persistant connections seem quite useful, however ive seen warnings about them maxing out the available connections due to the fact that theyre persistant and dont die...
Anyhow, my questions are....
1) Is connection pooling possible under php/mysql/apache, and if so, how do i go about implementing it.
2) Should I use persistant connections?
3) What settings, such as maximum connections etc, would you recommend using to handle the load?
Thanks,
Kefka
