MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: Creating XA Datasource in JBoss 7.1.1 for MySQL Cluster : Connection Read Only Error
Posted by: Todd Farmer
Date: December 17, 2013 12:02PM

Hi Manjnath,

To allow write operations against the failover host, you'll want to include failOverReadOnly=true property. Note that failover will keep connected to the first host while it remains available, so no real load-balancing is done here. The failover host (or hosts) is used only when the first host is thought to be unavailable.

Hope that helps!

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.