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

Kafka support for QLAFilter

    XMLWordPrintable

Details

    • MXS-SPRINT-251, MXS-SPRINT-252

    Description

      Original description:
      Currently the QLA filter is saved to a csv file,
      As a user id like the option to save the QLA filter to a table in mariadb, with a specific connection string or defaulting to the master node of monitor its attached to.

      Comments:
      This is likely unwise, as the amount of data could be immense (e.g. 100k QPS would cause 100k inserts/s). As Markus already suggested, a better tool is Kafka, as it's meant for storing event streams.

      Resolution:
      Added log_type=kafka and several Kafka-related settings to QLAFilter. Also, added setting logged_query_max_length, which limits the length of the logged query.

      Attachments

        Issue Links

          Activity

            People

              esa.korhonen Esa Korhonen
              allen.herrera Allen Herrera
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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