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

Allow sending commands to all shards

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • schemarouter
    • None

    Description

      For some use-cases, being able to send a CREATE DATABASE or other CREATE statement to all nodes would be useful. Examples of this are creation of commonly shared data tables.

      A possible implementation of this would be to implement handling of the ROUTE_TO_ALL hint in the schemarouter. This is currently an unused hint but using it for this purpose would seem useful.

      For commands that return results, an unordered "union" of the results could be created. This may be useful for collecting system information from all nodes while also allowing things like integrity checks with CHECKSUM TABLE.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          markus makela markus makela created issue -
          JoeCotellese Joe Cotellese (Inactive) added a comment -

          markus makela have you heard of a need for this from our customers?

          JoeCotellese Joe Cotellese (Inactive) added a comment - markus makela have you heard of a need for this from our customers?
          markus makela markus makela made changes -
          Field Original Value New Value
          Summary Send CREATE DATABASE to all shards Send commands to all shards
          markus makela markus makela made changes -
          Description For some use-cases, being able to send a {{CREATE DATABASE}} or other {{CREATE}} statement to all nodes would be useful. Examples of this are creation of commonly shared data tables.

          A possible implementation of this would be to implement handling of the ROUTE_TO_ALL hint in the schemarouter. This is currently an unused hint but using it for this purpose would seem useful.
          		For some use-cases, being able to send a {{CREATE DATABASE}} or other {{CREATE}} statement to all nodes would be useful. Examples of this are creation of commonly shared data tables.

          A possible implementation of this would be to implement handling of the ROUTE_TO_ALL hint in the schemarouter. This is currently an unused hint but using it for this purpose would seem useful.

          For commands that return results, an unordered "union" of the results could be created. This may be useful for collecting system information from all nodes while also allowing things like integrity checks with {{CHECKSUM TABLE}}
          markus makela markus makela made changes -
          Summary Send commands to all shards Allow sending commands to all shards
          markus makela markus makela made changes -
          Description For some use-cases, being able to send a {{CREATE DATABASE}} or other {{CREATE}} statement to all nodes would be useful. Examples of this are creation of commonly shared data tables.

          A possible implementation of this would be to implement handling of the ROUTE_TO_ALL hint in the schemarouter. This is currently an unused hint but using it for this purpose would seem useful.

          For commands that return results, an unordered "union" of the results could be created. This may be useful for collecting system information from all nodes while also allowing things like integrity checks with {{CHECKSUM TABLE}}           		For some use-cases, being able to send a {{CREATE DATABASE}} or other {{CREATE}} statement to all nodes would be useful. Examples of this are creation of commonly shared data tables.

          A possible implementation of this would be to implement handling of the ROUTE_TO_ALL hint in the schemarouter. This is currently an unused hint but using it for this purpose would seem useful.

          For commands that return results, an unordered "union" of the results could be created. This may be useful for collecting system information from all nodes while also allowing things like integrity checks with {{CHECKSUM TABLE}}.
          johan.wikman Johan Wikman made changes -
          Epic Link MXS-5324 [ 131045 ]
          johan.wikman Johan Wikman made changes -
          Assignee Max Mether [ maxmether ]

          People

            maxmether Max Mether
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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