I want to connect tomcat with mysql in a load balanced way.
Is this possible in Tomcat 7?
What changes are required in the following configuration?.
<Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="javauser" password="javadude" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/javatest"/>
i have 2 mysql servers localhost:3306 & secondhost:3306
Thanks