Hi,
We are using mysql cluster db and i have configured the pool using connector/j 5.0.8 version.
Pool settings -
URL - jdbc:mysql://10.3.2.17:3306,10.3.3.103:3306/databasename
RoundRobinLoadBalance - true
InitailPoolSize - 8
I see that on both the cluster instances , there are 4 connections open.
mysql>show processlist;
Now if i kill one of the cluster nodes , ideally the second node should start handling the requests.
server log start throwing exception - could not allocate a connection..
Does glassfish support mysql db cluster failover ?
[Message sent by forum member 'kbsangha' (kbsangha)]
http://forums.java.net/jive/thread.jspa?messageID=324257