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

A passive Maxscale with cooperative monitoring should not acquire exclusive server locks

    XMLWordPrintable

Details

    • Task
    • Status: In Progress (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • 26.10.0
    • mariadbmon
    • None
    • MXS-SPRINT-268, MXS-SPRINT-269, MXS-SPRINT-270

    Description

      Historically, we have advised against combining the passive-setting with cooperative_monitoring_locks. In existing MaxScale versions, what happens is that a passive MaxScale can still take the locks (but not perform failover), so that routing queries will work even if no MaxScale is active. The downside of this approach is that the passive MaxScale will not relinquish the locks even when the active MaxScale comes back online. Thus, no MaxScale can perform failover if required.

      With this change, the passive MaxScale will not take the locks, and will also release any locks it may have acquired previously. The assumption is that if cooperative monitoring is being used with active/passive, then someone/something is keeping track of the situation and ensures one MaxScale is always active.

      Original description:
      When maxscale is in mode passive:true , all monitors with cooperative monitoring should not be allowed to take locks. This means that an external script or program (e.g. Keepalived) or the DBA must ensure that one MaxScale is always active.

      Attachments

        Activity

          People

            esa.korhonen Esa Korhonen
            allen.herrera Allen Herrera
            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.