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

Broken slave promoted to master when no other servers are available

    XMLWordPrintable

Details

    • MXS-SPRINT-195

    Description

      In a two node setup, if the slave server breaks due to some SQL thread problem (e.g. error 1032 ER_KEY_NOT_FOUND) and then the master goes down, MaxScale will emergency promote the slave so that the cluster stays usable. This is unwanted behavior and often users would prefer that MaxScale simply waits (perhaps for a long time) for the master to come back.

      The logic should be changed so that even a broken slave (SQL or IO thread stopped, but not both) prevents new master selection. Only if both are stopped (usually requires "STOP SLAVE"), new master can be selected as this means the dba is modifying the cluster.

      A more resilient setup can be assumed to have multiple slaves so that at least one can be properly promoted by failover.


      Original description:
      Is there a way to configure maxscale to not promote a slave to master if the slave is still applying relay logs (behind master)?
      Related Jira issue: MDEV-32370

      Attachments

        Issue Links

          Activity

            People

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