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...
deployment
mysql
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