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

SELECT INTO OUTFILE is routed to all servers

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.2.11
    • 2.3.1
    • readwritesplit
    • None
    • MXS-SPRINT-69

    Description

      All queries that have a INTO OUTFILE component are routed to all servers. This is a somewhat questionable routing decision as the query actively modifies the file system on the slave server.

      A more reasonable approach would be to treat the query as if it was modifying the database itself (in a way it does) and route it to the master. This would mirror the routing behavior that LOAD DATA INFILE has.

      Attachments

        Issue Links

          Activity

            People

              johan.wikman Johan Wikman
              markus makela markus makela
              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.