I have a JEE 6 application deployed on JBoss 7.1 that currently connects to a standalone MySQL instance. It connects to a localhost MySQL using a standard datasource.xml (deployed on app server) and persistence (deployed in application .war), example below.
I wish to configure my application now to talk to an Amazon RDS MySql instance running in master-slave mode. Recommended configuration is to write only to the master and read only from the slaves. I presume this is achieved by datasource.xml edits but how exactly should I achieve this? Is there a sample -ds file available etc?
<?xml version="1.0" encoding="UTF-8"?>
<datasources xmlns="http://www.jboss.org/ironjacamar/schema">
<!-- to be copied to the deployments folder before the war is deployed but
after the mysql connector jar is copied to the deployments folder -->
<datasource jndi-name="java:jboss/datasources/mydb"
pool-name="mypool">
<connection-url>jdbc:mysql://localhost:3306/mydb_test</connection-url>
<driver>mysql-connector-java-5.1.22-bin.jar</driver>
<pool>
<max-pool-size>30</max-pool-size>
</pool>
<security>
<user-name>user</user-name>
<password>pass</password>
</security>
</datasource>
</datasources>
Perhaps I define multiple datasources in one xml file, slave datasources are defined as readOnly and one master datasource is configured as a standard connection? If so does the container then handle sending writes and reads to the appropriate datasource?
Thanks,
T
