Are there any ways to implement persistent connections to different databases under one instance of Apache? From my reading of Apache::DBI and from some of my testing it appears that this can not be done. Here is what I want to do. Server1 is running multiple named based virtual hosts. Each of the database run on different servers.

server1 (app1) -> db1
server1 (app2) -> db2
server1 (app3) -> db3

The most important and most used application connects to db1 and is running fine under apache and apache::dbi, but there are some smaller apps that we tried to bundle into this environment that need to connect to other servers running different database instances.

I don't want to eliminate apache::dbi and just use dbi. I don't want to get new machines to handle these smaller apps. I don't think I can have multiple instances of apache on a single Linux server, but am not sure.

I am thinking that I need to set up a standalone Soap Server running on another port to handle the connections to the other databases, without any sort of persistence, which for performance reasons would probably be okay.

Any experience on this matter, or any other design ideas?

Thanks.


Reply via email to