Single mod_perl Instance Serving Multiple Domains

I manage several low-traffic websites sites.  These sites use the classic 2-server Apache/mod_perl architecture.  The front-end server is a light Apache instance hosting a WordPress blog.  The heavy, back-end server is mod_perl-enabled Apache serving various web applications I’ve created.

To the best of my understanding, mod_perl/Apache can only set-up and cache a single database connection.  Is that right? Only one database connection per mod_perl instance?

But my applications need to access several databases.  All the databases are hosted on a single instance of MySQL.  I’ve set it up to use that single cached database connection, and also distinguish requests from the different front-end domains.  Lastly, I’m experiencing a problem using $r->push_handlers.  Let me tell you about it and ask for your feedback. First, the set up. Continue reading “Single mod_perl Instance Serving Multiple Domains”