Forum Discussion

forsan_102218's avatar
forsan_102218
Icon for Nimbostratus rankNimbostratus
Jul 23, 2014

Anyone running MySQL through a BigIP?

Hi,

 

I'm trying to run MySQL traffic through a Big IP, but I'm having some issues.

 

I'm load balancing four read databases and I'm getting "Communication link failure" messages in the client log. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

 

Anyone that can recommend some logging to use?

 

Say one or two queries fail during one hour. So tcpdump to a file will generate a looot of data.

 

Regards Andréas

 

deployment
mysql

3 Replies

Sort By
  • samstep's avatar
    samstep
    Icon for Cirrocumulus rankCirrocumulus
    Jul 23, 2014

    Are you using the MySQL proxy iApp? (it is available for v11.x here: https://devcentral.f5.com/wiki/iApp.MySQL-Proxy-iApp.ashx

     

    If connection errors are rare it is possible that you get load-balanced to an overloaded/unresponsive pool member - check the ltm logs for any pool members being down at the same time when you get the jdbc communications link failure.

     

    Enabling the TCP Reset reason logging on F5 can also help - see Solution l13223

     

    Sam

     

  • verifi_net_ops_'s avatar
    verifi_net_ops_
    Icon for Nimbostratus rankNimbostratus
    Jul 12, 2016

    modify the TCP timeout settings for the TCP profile, but also ensure you are NOT using auto SNAT. specify a snat pool and modify the snat TCP timeout as well. That should fix it.