Tomcat jdbc fault tolerant hosts

I am currently using tomcat7 with its own jdbc pool as described here: http://www.tomcatexpert.com/blog/2010/04/01/configuring-jdbc-pool-high-concurrency .

I also have a master / master configuration for mysql (replicated), and I was wondering how (if possible ...) to configure tomcat to switch to another resource between two mysql. therefore, for example, if mysql1 goes down, open the entire pool again against mysql2. Any ideas on how to achieve this?

I also don't mind switching to another jdbc implementation, if not tomcat.

+3
source share

All Articles