Hi Albert -
On Tue, 13 Dec 2005, Albert Vila wrote:
I thought the persistent connection was only one for all childs.
What happens then if I have 1000 childs each one with 1 db connection? This
means 1000 database connections. How do you setup apache + mod_perl in this
environment?
Typical mod_perl setups include a light-weight front end Apache which
serves all static content and which reverse-proxies requests for dynamic
content to a heavier-weight back end Apache running mod_perl, see:
http://perl.apache.org/docs/1.0/guide/strategy.html#Adding_a_Proxy_Server_in_http_Accelerator_Mode
In this setup you typically have *far* fewer mod_perl children running at
a given time than if you used only a single mod_perl front end.
Of course under heavy load it is still possible to run up to your database
connection limit, even with the two-Apache setup, in which case you'd need
to look into the other options that people have suggested.
Larry
