Mysql-proxy doesn't failover

[R G]

Hello All,

I am experiencing the following behavior and I was wondering if the community has tackled it before.

I have mysql-proxy (0.8.2) running on amazon linux (in ec2) connected to 2 mysql servers. THe client can connect to the proxy and load balancing works fine. My problem is this: I have a client that is connected (via the proxy) to a server. I then close the server and try to execute simple insert command. I was expecting the proxy to redirect the request to second server. However I am getting the this exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure.

The client in this case is a Java program using mysql-connector-java-5.1.17-bin.jar

Interestingly, when I run the same test through a Mysql command line, the proxy tells me the connection to server A is lost, it reconnects to server B and execute the insert command.

Any ideas how to solve this or am I doing something wrong?

Thanks.