MySQL server dropping connectivity to DMZ web app

Valued Contributor

I am working with JAMF support on this issue, just casting a wider net for advice…

Clustered environment:
MySQL 5.6 on 2012 R2 VM
JSS 9.98 on a 2012 R2 VM (internal)
JSS 9.98 on a 2012 R2 VM (DMZ)

Internal operability is fine. Problem is with DB connectivity to the web app in the DMZ. It will work fine for a few days, I’ll see machines off network checking in just fine. Nice! Then suddenly the communication stops (internal is still fine though). The only way to restore connectivity seems to be rebooting the database server. Restarting the MySQL service is not enough.

This problem is old. I’ve upgrade the JSS several times, upgraded MySQL once, and rebuilt the DMZ server from scratch; problem still exists. Multiple departments are responsible for different aspects of the infrastructure (server, network, security) all saying their piece is configured fine.

We do, sadly, have McAfee on these servers and there are no OAS exclusions in place that I’m aware of, though I’m working to do so, at least on the DB folder.

So with that, I’m open to suggestions of where to focus here.