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

Keep session consistent via session variable tracker

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • None
    • N/A
    • None
    • None

    Description

      Let server told mxs the latest variable changes in ok packet, when mxs send result back to client ,at the same time, apply these changes to other backends;

      Attachments

        Issue Links

          Activity

            markus makela markus makela added a comment - - edited

            If I understand this correctly, the idea is to execute all variable (mainly user variables) modifications on the master and propagate the results to the slaves. This would remove the need for the use_sql_variables_in parameter as well as improve overall performance of user variable modifications.

            markus makela markus makela added a comment - - edited If I understand this correctly, the idea is to execute all variable (mainly user variables) modifications on the master and propagate the results to the slaves. This would remove the need for the use_sql_variables_in parameter as well as improve overall performance of user variable modifications.
            dapeng dapeng huang added a comment -

            Yes, and also resolve the problem of routing all queries to master after multi stmts or stored procedure be executeed;

            dapeng dapeng huang added a comment - Yes, and also resolve the problem of routing all queries to master after multi stmts or stored procedure be executeed;

            People

              toddstoffel Todd Stoffel (Inactive)
              dapeng dapeng huang
              Votes:
              0 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.