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”