MySQL active connection never bleed off to other pool member
I am running galera MySQL behind F5 with performance Layer 4 type and i have setup 3 mysql node in pool member with Priority so only 1 mysql node will be used and other two will be standby. So everything was good but i found today when i shutdown Primary node which was active and i found my application break and when i have checked logs found: (2006, "MySQL server has gone away (error(104, 'Connection reset by peer'))") So solution was restart application, look like active member mysql connection not bleeding off to other pool member, what is wrong with my setup?
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.
Use iRules-LX to Blue/Green Deployment
Hello I've been learning IRules-LX，I hope to get http post username through iRules,Then used the username call to node.js(mysql npm) select mysql database.if the username select result is "green".loadbalance to green pool. Or else loadbalance to blue pool. Has anyone ever tested it ? Is there an I/O bottleneck? Thanks everyone
Where to find raw HTTP Request for ASM violations?
Where can I find the raw HTTP Request that is logged with ASM violations? The version that is printed to the browser in Security->Event Logs->Application->Requests appears to be inserting a Replacement Character at the location of (presumably) a multibyte UTF-8 character. If I cut and paste the text from the browser, it contains a UTF-8 Left-to-Right Embedding character and the Replacement Character (with words in between). But I'm guessing that Replacement Character is not what the client actually sent, just what I'm ending up with after it's been processed by the web stack. I have explored the underlying MySQL database a little and the violation itself is logged in PRX.REQUEST_LOG, but the HTTP Request that gets shown when I browse in the web UI is not in that table, nor do I see it in any other table in PRX. It's in the database somewhere, because I can string match it in ibdata1. Does anyone know which table stores the HTTP Request raw data for ASM violations? Is there any documentation for the schema of the databases in MySQL on the F5 (DCC, PLC, PRX, WIZ)?
Connection to MySQL using BIG IP
Dear all Sorry for the very basic questions but I am new in this environmet ( I am working on a project where I have to balance 3 read/write servers thorough a BIG F5 that costumer manages ) What are the required changes in configuration to a Java client to interface with BigIP ? Do I need to use Connector/J ? Can I use the virtual IP of load balancer in the connection string ? What do I need to have installed in the BIG IP ?Access to F5's mysql from remote server
Hi there, I need to export a lot of learning suggestions from the ASM together with request data which triggered these suggestions. GUI does not allow to export learning suggestions. I realized that ASM learning suggestions are stored in the local mysql database PRX, to which I have access from F5's CLI as the 'asm' user. In order to work with these data efficiently and also because F5 does not allow me to install additional Python modules directly on the F5, I thought I could connect to this database from my remote server. But it looks like the F5 is refusing TCP/3306 connections although the 'asm' user is granted required privileges: GRANT USAGE ON *.* TO 'asm'@'%' IDENTIFIED BY PASSWORD '****' I assume that mysql is only allowing local connections from localhost, but I cannot verify it because I am not able to find the my.cnf on the F5 system. I tried connecting through management interface and also selfIP, but nothing worked. Port lock-down for my selfIP is allow any. According to netstat, F5 should be listening to port 3306 on all interfaces: tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 19397/mysqld TCPDUMP on the last firewall in front of the F5 shows me SYN reaching the F5 and immediate RST sent back from the F5. Any ideas how to connect to F5 mysql from remote server? What do I need to check further? Is it even allowed by the system? thanks.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 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
Embeded Mysql ASM database - how to display src_ip datas from PRX.PROXY_LOG
Hello, The reporting tool built into the GUI ASM can not meet my specific needs analysis. Therefore, to meet these needs I perform some SQL queries directly in the internal MySQL database. The only thing I miss: How to get the IP addresses in a viewable format (as stored in varbinary (16)? Outside a CAST or CONVERT, the data is encrypted it?Big IP with MySQL Group Replication
Hi guys, Has anyone had successfully configured Big IP (11.6) to work with MySQL (5.7.20) Group Replication? I have 3 MySQL servers, server 1 is the primary all requests are sent to him, read and write, the two others servers are only there for High Availability. Basically I have a service running on each MySQL servers sending http code for probing, with this the health monitor is working fine. Other than that nothing is working. Is this doable to have Big IP working with MySQL Group Replication? I have seen the MySQL Proxy iApp but this is not really what I need. Thanks,