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:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 4h 10m
                  4h 10m

                  Git Integration

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