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

Switchover fails randomly

    XMLWordPrintable

Details

    • 2017-49

    Description

      Running switchover may leave some slaves only [Running] and they cannot continue replication. The effect is somewhat random and probably depends on timing between queries during switchover and replication lag. Seems to be fixed by swapping the order of "FLUSH TABLES;" and "FLUSH LOGS;" during master demotion. Another way to fix this would be to add some slack time and more checks and MASTER_GTID_WAIT-calls to make sure the cluster is in sync before "STOP SLAVE".

      Attachments

        Activity

          People

            esa.korhonen Esa Korhonen
            esa.korhonen Esa Korhonen
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.