Connection to MySQL using BIG IP

Hi JPBentes,

Load balance of SQL is not really usual, I don't think the big-ip adds great value here. There are no tools to make sql protocol easy to manage afaik.

There are sql monitors that may help you improve resiliance but nothing else apart from that.

From the big-ip point of view you can configure a virtual server with no protocol profile. Oneconnect profile may help you save you some tcp handshakes. Apart from this I don't see much.

Load balance based on the connection string should be doable but it doesn't look an easy task. You will need to go down TCP layer and perform binary scans to get the information you need to load balance. This can be useful: https://devcentral.f5.com/articles/irules-101-17-mapping-protocol-fields-with-the-binary-scan-command