On 03/02/2007, at 8:59 AM, Nicholas Milkovits wrote:
Hi all,
I have been tasked with trying to figure out how to share one
database pool for all child processes/worker threads for a single
apache2 virtual host using mod_python. I came across this thread
from 2003
http://mail-archives.apache.org/mod_mbox/httpd-python-dev/
200306.mbox/[EMAIL PROTECTED]
which discusses adding the ability to have objects in shared memory
to mod_python but the thread seems to have went dead. Is there a
proposed or working solution for this?
Having multiple threads in a process sharing a database pool is fine,
but not
sure it even makes sense to share a database pool across processes. What
existing technology do you know of in other systems that allow a
database
connection pool to be shared across processes so we can look at it and
understand more about what you want.
FWIW, you might also look at:
http://httpd.apache.org/docs/2.2/mod/mod_dbd.html
I know this doesn't help you with mod_python as this part of Apache
isn't exposed
through mod_python. It might give you an idea of what is available
through other
modules in Apache. That said, although there is no APIs in
mod_python, provided
you were using mod_python 3.3, there are ways with a bit of SWIG
generated Python
wrappers that you could make use of it if it did really help you in
some way.
Graham