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

Implement simple failover script using GTID

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: 10.2
    • Component/s: None
    • Labels:

      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

            Assignee:
            knielsen Kristian Nielsen
            Reporter:
            knielsen Kristian Nielsen
            Votes:
            4 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated: