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

Filter for controlling what statements are allowed

    XMLWordPrintable

Details

    • New Feature
    • Status: In Progress (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • 25.08
    • None
    • None

    Description

      With this filter, it would be possible to control what kind of statements are allowed. For instance, you could prevent writes, DDL, etc. and even reads, if you wanted to.

      One context where this would be useful is when you have one listener + readconnroute to be used for writing and one listener + readconnroute to be used for reading. However, that setup does not prevent someone from opening a connection to the latter listener and proceeding to write. With this filter, it could be ensured that no writes go through.

      If you want to use readwritesplit to provide load balanced read access to a cluster, you could setup a service with this filter and be ensured that no writes will go through, not even by a super user.

      When the system is ready, you could include this filter in all services to prevent all DDL.

      Attachments

        Issue Links

          Activity

            People

              markus makela markus makela
              johan.wikman Johan Wikman
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.