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>