Forum Discussion
forsan_102218
Nimbostratus
NimbostratusAnyone 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
samstepCirrocumulus
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_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.
forsanAltostratus
The issue we had with MySQL was with CMP and packet filters. The BigIP changed tmm for the traffic and blocked the traffic due to the return traffic was not allowed through the packet filter.
https://support.f5.com/kb/en-us/solutions/public/12000/800/sol12831.html
Br Andréas