[jboss-user] [JCA/JBoss] - Re: jboss ha datasource configuration to the same host

[adrian@jboss.org]

"brettcave" wrote : Would something like this work?
  | 
  | I am using heartbeat + ldirector for HA and loadbalancing of sql servers.
  | 
  | I find that jboss applications become unavailable for a while if the connection gets lost - which happens occassionally due to packet loss. So in trying to get a stable jboss + mysql infrastructure, I would like to use
  | <ha-tx-local-datasource>
  | <connection-url>jdbc:mysql://ha.host:3306/db|jdbc:mysql://ha.host:3306/db</connection-url>
  | 

I don't think that will work? Looking at the HAXAConnectionFactory the urls
get parsed to an "XAData" which is treated as equal if the urls are the same.

But then again it stores them in a List rather than a Set so it might still work?

anonymous wrote : 
  | Also, i read somewhere that using background-validation with check-valid-connection-sql can cause a conflict, but cant find further info on it... any recommendations for detecting whether connections are valid?
  | 

??? It is duplicate work, I don't know it is a conflict since one works on
idle connections, the other on connections just about to be used (i.e. not idle).

anonymous wrote : 
  | lastly, is using jdbc:mysql://ha.host:3306/db?autoReconnect=true the same as leaving "autoReconnect=true" off the URL and adding it to <connection-property> ? 

Completely broken if you use any form of transactions.
AFAIK, the reconnect will use a different connection that knows nothing about previous
work in an ongoing transaction.

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4221316#4221316

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4221316