Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Admin Only Port for Emergencies #8943

Open
reltuk opened this issue Mar 5, 2025 · 3 comments
Open

Add Admin Only Port for Emergencies #8943

reltuk opened this issue Mar 5, 2025 · 3 comments
Assignees
Labels
customer issue enhancement New feature or request sql server Issues related to the built in SQL server

Comments

@reltuk
Copy link
Contributor

reltuk commented Mar 5, 2025

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.

@timsehn timsehn added enhancement New feature or request sql server Issues related to the built in SQL server customer issue labels Mar 5, 2025
@macneale4 macneale4 self-assigned this Mar 18, 2025
@macneale4
Copy link
Contributor

If we're blocking, we should just block until a new connection becomes available.

dolthub/vitess#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
Copy link
Contributor

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
Copy link
Contributor

Partially implemented with: dolthub/vitess#406

Updating description to be about admin port.

@macneale4 macneale4 changed the title Improve max_connections enforcement and backoff. Add Admin Only Port for Emergencies Mar 26, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
customer issue enhancement New feature or request sql server Issues related to the built in SQL server
Projects
None yet
Development

No branches or pull requests

3 participants