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

Support statement pipelining of reads and multi-target queries

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • N/A
    • readwritesplit
    • None

    Description

      This is a continuation of MXS-1245.

      With MXS-1245 implemented, queries that are routed to the master are executed in a streaming fashion. This can be relatively easily extended to cover queries that target slaves but the major hurdle with that is the target selection code has to be modified to be aware of it.

      For multi-target queries the issue is more complex. In theory this is simple: append the command to the history and execute it on all backends. The replier for all the executed session commands should be the same server. The accounting of the session command history must be updated for this to be doable.

      The problems come when different target types are mixed while streaming queries. The streaming of session commands and single-target queries can be done if the replying backend is the same as the replier of the session command.

      Attachments

        Issue Links

          Activity

            People

              markus makela markus makela
              markus makela markus makela
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.