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

Give a way to use slave_selection_criteria = LEAST_BEHIND_MASTER with Galera

    XMLWordPrintable

Details

    Description

      Looks like readwritesplit router assumes that Galera nodes are all always in sync. In reality they may have write sets pending to be applied and wsrep_local_recv_queue may be used as a measure of current "lagging" for Galera node.

      With this we may be able to apply slave_selection_criteria = LEAST_BEHIND_MASTER and route to the Galera node that is more close to "master" or less loaded.

      Attachments

        Activity

          People

            toddstoffel Todd Stoffel (Inactive)
            valerii Valerii Kravchuk
            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.