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

Send calls to READS SQL DATA procedures to slaves

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Icebox
    • Component/s: None
    • Labels:
      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

          Activity

            People

            Assignee:
            toddstoffel Todd Stoffel
            Reporter:
            hholzgra Hartmut Holzgraefe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration