Growing beyond MySQL, or accommodating hundreds of connections
I'm the last developer standing on a team that uses MySQL as the database for a Tomcat webapp. We've got dozens of web requests coming in at any given moment, and about 50-60 M2M connections happening via an MQTT-like Java service running (also running on the webserver). Each request might call for making a dozen individual dB queries itself, but more often than not it's simple stuff like pulling lists of locations, etc, the complicated aspects are where we pull together reports representing data received over long periods of time from tables that contain millions rows.
The issue is that I'm running into "Too Many Connections" at different points of the day.