This content has been marked as final.
Show 2 replies
-
1. Re: Using MySQL replication driver with JBoss Transactions
jaikiran Jun 28, 2010 9:03 AM (in response to paradigmza)Try configuring this on the datasource from which you obtain the connection:
<connection-property name="readOnly">true</connection-property>
I haven't tried it myself so not sure whether it's going to work. See this doc for the details http://community.jboss.org/wiki/configdatasources
-
2. Re: Using MySQL replication driver with JBoss Transactions
paradigmza Jun 28, 2010 9:48 AM (in response to jaikiran)That would work if I had 2 data sources (and 2 entity managers). The mysql replication driver works by using a master/slave setup in the same datasource.
<connection-url>jdbc:mysql://master,slave1,slave2,slave3/dbname</connection-url>
Setting this to read-only would then tell the driver to only use the slaves (and never use the master), and hence defeats the purpose of using the replication driver.