[MXS-1978] SELECT INTO OUTFILE is routed to all servers Created: 2018-07-13  Updated: 2018-11-08  Resolved: 2018-11-01

Status: Closed
Project: MariaDB MaxScale
Component/s: readwritesplit
Affects Version/s: 2.2.11
Fix Version/s: 2.3.1

Type: Bug Priority: Major
Reporter: markus makela Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MXS-2096 SELECT ... INTO OUTFILE is routed to ... Closed
Sprint: 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.


Generated at Thu Feb 08 04:10:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.