dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Add Admin Only Port for Emergencies

Open reltuk opened this issue 10 months ago • 3 comments

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.

reltuk avatar Mar 05 '25 20:03 reltuk

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.

macneale4 avatar Mar 18 '25 23:03 macneale4

I've decided to add the back_log and max-connections-timeout options because they hanging behavior is pretty horrible for any production application.

macneale4 avatar Mar 20 '25 23:03 macneale4

Partially implemented with: https://github.com/dolthub/vitess/pull/406

Updating description to be about admin port.

macneale4 avatar Mar 25 '25 23:03 macneale4