doris icon indicating copy to clipboard operation
doris copied to clipboard

[enhancement](user) Support limit user connection by ip

Open stalary opened this issue 1 year ago • 14 comments

Proposed changes

Issue Number: close #xxx

In some cases, multiple services may use a common account, but the service may not be able to control the number of connections well, and we need to restrict it in the doris.

Such as prod and stage environment use common user, but stage database connection use too many due to user connection too many.

This parameter can be used to refine user connection limits.

The use way as follow

SET PROPERTY FOR 'root' 'max_user_ip_connections' = '50';

You can use it control server connect number per ip(such as podIp in k8s) and control it concurrent.

stalary avatar Aug 04 '24 15:08 stalary

Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR

Since 2024-03-18, the Document has been moved to doris-website. See Doris Document.

doris-robot avatar Aug 04 '24 15:08 doris-robot

clang-tidy review says "All clean, LGTM! :+1:"

github-actions[bot] avatar Aug 04 '24 15:08 github-actions[bot]

clang-tidy review says "All clean, LGTM! :+1:"

github-actions[bot] avatar Aug 04 '24 15:08 github-actions[bot]

clang-tidy review says "All clean, LGTM! :+1:"

github-actions[bot] avatar Aug 11 '24 10:08 github-actions[bot]

clang-tidy review says "All clean, LGTM! :+1:"

github-actions[bot] avatar Aug 11 '24 10:08 github-actions[bot]

run buildall

morningman avatar Aug 11 '24 14:08 morningman

PR approved by at least one committer and no changes requested.

github-actions[bot] avatar Aug 11 '24 14:08 github-actions[bot]

PR approved by anyone and no changes requested.

github-actions[bot] avatar Aug 11 '24 14:08 github-actions[bot]

run buildall

stalary avatar Aug 13 '24 14:08 stalary

run buildall

morningman avatar Aug 14 '24 13:08 morningman

run buildall

morningman avatar Aug 19 '24 14:08 morningman

PR approved by at least one committer and no changes requested.

github-actions[bot] avatar Aug 21 '24 04:08 github-actions[bot]

run buildall

stalary avatar Aug 23 '24 01:08 stalary

run buildall

stalary avatar Aug 29 '24 01:08 stalary

run p0

morningman avatar Aug 29 '24 14:08 morningman

We're closing this PR because it hasn't been updated in a while. This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable. If you'd like to revive this PR, please reopen it and feel free a maintainer to remove the Stale tag!

github-actions[bot] avatar Feb 26 '25 00:02 github-actions[bot]