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

Send calls to READS SQL DATA procedures to slaves

    XMLWordPrintable

Details

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

    Description

      Right now all procedure CALL statements are sent to the current master, as maxscale can't tell whether the procedure body would change any data or not. So load balancing of procedure calls can't happen (unless enforcing slave side execution somewhat manually, e.g. with "run on slave" hint filter hints)

      A procedure declared as READS SQL DATA is known to only read, not write, though. So when taking such procedure metadata into account, Maxscale could send calls to such procedures to read-only slaves.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              hholzgra Hartmut Holzgraefe
              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.