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

Track more replication settings during failover/switchover

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 25.10.2
    • 26.10.0
    • mariadbmon
    • None
    • MXS-SPRINT-272, MXS-SPRINT-274

    Description

      Conclusion:
      Monitor tracks and maintains the values of Master_SSL_Verify_Server_Cert, Replicate_Ignore_Server_Ids, Replicate_Do_Domain_Ids, Replicate_Ignore_Domain_Ids and SQL_Delay. During a switchover, the demoting primary inherits the values for these replication options from the previous replica (that is getting promoted). During rejoin, the joining replica uses the same values as the current primary used before being promoted.

      Original description:
      The monitor should track more replication options for servers, so that they can be applied when a server gets demoted or promoted. Ideally, the monitor would also set them correctly for servers rejoining the cluster. The options that need tracking include MASTER_SSL, IGNORE_SERVER_IDS, and others that apply to CHANGE MASTER TO. Certificate and keyfile paths are perhaps best ignored, as the correct values may depend on the server and thus are not transferable.

      Additionally, the monitor could track the values of replication filter settings described at https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-filters

      Only some of the filter settings can be runtime altered.

      Attachments

        Issue Links

          Activity

            People

              esa.korhonen Esa Korhonen
              esa.korhonen Esa Korhonen
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 5d Original Estimate - 5d
                  5d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 8d
                  8d

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.