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

priority-based replica selection in mariadbmon failover

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      When multiple replicas are equally up to date and suitable for promotion, there is no configurable mechanism for mariadbmon to select the best promotion replica to express a preference among them.

      This enhancement proposes extending mariadbmon to support priority-based replica selection by utilizing the existing priority server attribute, similar to how it is used by galeramon.

      This would provide greater flexibility for asynchronous replication deployments without altering the current failover logic for determining eligible promotion candidates.

      The idea is to extend MaxScale to include this functionality, following the same logic of negative value means DO NOT USE the server, and lowest value has a higher preference. This provides the user with a more flexible approach in selecting up to date replicas. In practice MaxScale will most likely not trigger a failover in sub-second timescales so by then multiple replicas may be in the same state replicating from the now dead master. Optionally adding this final check if use_priority=true and setting priorities to individual hosts would be a useful improvement.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Koustuv Koustuv Chatterjee
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.