2 Replies Latest reply on Dec 8, 2006 4:49 AM by Arno Raps

    Jboss cluster on a replicated mysql db

    Arno Raps Newbie

      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>