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

Better handling of queries in the binlog router

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Do
    • 1.2.1
    • N/A
    • binlogrouter
    • None

    Description

      This is a general comment and a known issue of the current code but I think it's worth making the issue more visible as it may cause some confusion.

      A colleague recently issued this query to a binlog server:

      mysql> select @@server_uuid, @@server_id, @@global.hostname;
      +--------------------------------------+
      | @@server_uuid                        |
      +--------------------------------------+
      | 6800aaaa-0869-1aa5-8550-1458aaaaeed0 |
      +--------------------------------------+

      The result as you see gives a single column resultset whereas the query requested 3 columns of data. The parsing of the statements by the binlog router is rather basic at the moment. It would be good if this could be more complete, and at least in the case above, if the query does not match what the binlog router understands it should probably give an error rather than partially respond with an answer as that may confuse the client (in this case orchestrator).

      So please consider improving the parsing of the statements and reporting any issues appropriately.

      Note: the BLR is not a RDBMS so it's not expected that it can understand all SQL commands. All that we want is that it is able to parse enough commands to be able to provide the right responses to a slave and also some status output needed for monitoring or some commands needed to manage the BLR's state.

      Attachments

        Issue Links

          Activity

            People

              toddstoffel Todd Stoffel (Inactive)
              simon.mudd Simon J Mudd
              Votes:
              2 Vote for this issue
              Watchers:
              3 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.