Forum Discussion

Clayton's avatar
Clayton
Icon for Altocumulus rankAltocumulus
Jun 08, 2021

MySQL Monitor (or EAV) with SSL?

We are migrating to MySQL, and I would like to use our F5 LTM to load balancer the ( MySql Enterprsie, 3-node) cluster. I have upgraded to Bigip 15.1.3 (from 14.x.x) per Support as version 15 should ...
application delivery
BIG-IP
LTM
mysql
ssl
Clayton's avatar
Clayton
Icon for Altocumulus rankAltocumulus
Jun 09, 2021

It seems my instances need to allow more connections or something, after turning off the mysql monitor and leaving it for a while, I am able to connect using the mysql client found on the Bigip CLI. Copied up the CA, client cert, and client key, and can connect that way ..

 

Trying out the example from the MSSQL link you provided (using a dummy virtual server, and have the monitor point at that)

 

 

  • Nikoolayy1's avatar
    Nikoolayy1
    Icon for MVP rankMVP
    Jun 09, 2021

    Yes, you can test using F5 VIP as for MSSQL but for the mysql monitor so it can work with TLS traffic as per K40700745 .

     

     

     

    Also see this article https://support.f5.com/csp/article/K15242 to maybe send smaller number of probes per connecton.

     

     

     

    By F5 internal mysql client you mean "/usr/bin/mysql " that is used primary fo accessing the F5 local mysql database for AVR/ASM/APM statistics? If this is the case you can try making externel linux bash script monitor by using the sql client but it will be hard work and I hope the other previous idea with an F5 VIP helps. But just in case I will share this as examples that can be rewriten:

     

     

     

    https://support.f5.com/csp/article/K71282813

     

     

    https://devcentral.f5.com/s/articles/ltm-external-monitors-the-basics

     

     

    https://support.f5.com/csp/article/K31435017