Greetings Fellas,
I'm in need of a new architecture for the web server that I host. I'm currently running my application on the standard
Tomcat Servlet container and use MySQL as my database. I'd like to create two separate databases that are structured quite different to efficiently handle two separate requests. However, I'd like to access both of these databases on a single Tomcat instance (I'd like to avoid clustering). Could anyone point me in the right direction on how I would go about accomplishing this? I noticed JOTM might be a solution, but it seems a bit of an overkill for what I want to do. I'm looking for a simpler solution, unless yall recommend JOTM. Any help would be appreciated.
-Tyler