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 have a working MySQL Monitor. However, it still times out connecting. A simple telnet test from the LTM CLI connects to the mysql port, so networking is not an issue.
I then had the idea of copying up the client SSL certs and seeing if the local mysql client on the LTM would connect, but I get an error about "ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory"
So the built-in MySQL Monitor can't use SSL (what century is this anyway?), and the on-board mysql client apparently has issues with SSL as well.
Any way to do this? I'd rather not give my developers a reason to set up some kind of HA Proxy junk. I don't need more infrastructure to maintain.