[jboss-user] [Clustering/JBoss] - Jboss cluster on a replicated mysql db

[arnoraps]

I am running a mysql db in replication setup. Now i want my Jboss cluster to connect to one of these db's, and if it fails to reconnect to the other one. 
Is this possible? My mysql-ds.xml is now:

  <local-tx-datasource>
    <jndi-name>MySqlDS</jndi-name>
    <connection-url>jdbc:mysql://10.48.1.63,10.48.1.64:3306/jms</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>jboss</user-name>
    ******
    <connection-property name="autoReconnect">true</connection-property>
      
         <type-mapping>mySQL</type-mapping>
      
  </local-tx-datasource>


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3991966#3991966

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3991966