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

        Activity

          People

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