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

The MaxScale parser should be more flexible when it comes to system variables.

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.1
    • Fix Version/s: 2.0.0
    • Component/s: Core
    • Labels:
      None

      Description

      Currently MaxScale uses the SQL parser from the embedded library. That means that it will not recognize Galera variables, such as @@wsrep_node_name, but will at that point abort the parsing.

      The implication is that, for instance, select @@hostname, @@wsrep_node_name and select @@wsrep_node_name, @@hostname are routed differently. The former is routed to a slave, but the latter to master.

      The parser should be more relaxed so that it would not abort the parsing when it encounters an unknown system variable, as long as it looks like one. Then, what impact on the routing decision an unrecognized variable has, should be configurable via a configuration file.

      That way the behaviour of MaxScale would not be strictly dependent on it having exactly the same parser as the one in the backend.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              johan.wikman Johan Wikman
              Reporter:
              johan.wikman Johan Wikman
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: