Add Admin Only Port for Emergencies
When max_connections is reached, there is no mechanism for a DBA to login and start killing sessions. We could open an additional SQL port which only allows privileged user access. Similar to:
https://dev.mysql.com/doc/refman/8.4/en/administrative-connection-interface.html
Related to #8942.
If we're blocking, we should just block until a new connection becomes available.
https://github.com/dolthub/vitess/pull/404
That's the only low hanging fruit of this issue. I think if we want to get into rejecting connections, that's going to need some config.
For the last issue - an additional admin port - That would be great. We should do that, but it's considerably more work.
I've decided to add the back_log and max-connections-timeout options because they hanging behavior is pretty horrible for any production application.
Partially implemented with: https://github.com/dolthub/vitess/pull/406
Updating description to be about admin port.