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

Readwritesplit master_reconnection is incompatible with GET_LOCK

    XMLWordPrintable

Details

    • MXS-SPRINT-220

    Description

      A GET_LOCK() call with master_reconnection=true and master_failure_mode=fail_on_write may cause the lock on the primary node to be lost without the user being aware of it. This means that the only way to guarantee that the locking function calls are handled correctly is to disable reconnections to the primary node.

      A better way to deal with this would be to detect if a locking related function call is used and then disable the reconnections. This would make it always safe to use locking functions with MaxScale, regardless of the configuration.

      An improvement would be to disable it until all of the locks have been released but this would require the names of all the locks to be stored as well as the tracking of whether the locks were actually acquired.

      Attachments

        Activity

          People

            markus makela markus makela
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.