Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4990

Implement simple failover script using GTID

    XMLWordPrintable

Details

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

    Description

      GTID allows to automatically fail-over a master by promoting a slave as the
      new master, bringing it up-to-date with any other slaves and switching
      existing slaves to use the new master. The procedure is described in the
      documentation.

      https://mariadb.com/kb/en/global-transaction-id/#start-slave-until-master_gtid_posxxx

      We need a script that implements this procedure. The user can then run this
      script to promote a slave as a new master, simply by supplying connection
      information for all involved servers.

      Attachments

        Activity

          People

            knielsen Kristian Nielsen
            knielsen Kristian Nielsen
            Votes:
            4 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.