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

IO thread should expose its current GTID position

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.4
    • 10.0.7
    • None
    • None

    Description

      Master_info already has the field gtid_current_pos representing GTID of the last full transaction saved into relay log. It would be extremely useful to have this field exposed e.g. in the result of SHOW SLAVE STATUS.

      This information will be useful in failover scenarios. Currently when master dies we can't know which of the slaves has all the latest transactions in their relay log until SQL thread executes all of them. But if Master_info::gtid_current_pos is visible we'll be able to know exactly what transactions each slave has and which GTID position it will be at when SQL thread catches up with all relay log events.

      Attachments

        Activity

          pivanof Pavel Ivanov created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Assignee Kristian Nielsen [ knielsen ]
          knielsen Kristian Nielsen made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          knielsen Kristian Nielsen made changes -
          Fix Version/s 10.0.7 [ 14100 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 28617 ] MariaDB v2 [ 43173 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 43173 ] MariaDB v3 [ 62237 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 62237 ] MariaDB v4 [ 146980 ]

          People

            knielsen Kristian Nielsen
            pivanof Pavel Ivanov
            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.