Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-7666

Impose resource limits from user grants at the MaxScale level

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • Core
    • None

    Description

      The resource limits that can be set with the GRANT statement are not currently enforced by MaxScale and are only enforced by MariaDB. Enforcing them at the MaxScale level would mean that e.g. MAX_USER_CONNECTIONS cannot be violated by going through MaxScale which then offloads traffic to multiple nodes.

      However, one could argue that e.g. the user-based connection limits do not make as much sense when talking about a proxy as it's the database itself where the actual resources end up being used. Thus, making this behavior optional would seem smart.

      Attachments

        Activity

          People

            Unassigned Unassigned
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.