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

Incorrect implementation of Galera replication

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • N/A
    • binlogrouter
    • None

    Description

      Hi,

      The implementation of MDEV-1980 is incorrect. The GTID is not synced within the Galera cluster, therefore the gtid_slave_pos cannot be used for reconnecting the replication stream.

      This implementation reads to inconsistent slave and not working point in time recovery.

      The way to do this is to read the binlog that was retrieved from the old node, find the 'Xid' that belongs to the most recent transaction, then connect to a next node and find the same 'Xid' on the next node's binlog.

      The procedure is risky because at SST all binlogs are removed on the joiner node.

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MXS-1980 Support Galera cluster nodes as masters for Binlog Router

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-20720 Galera: Replicate MariaDB GTID to other nodes in the cluster

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              Unassigned Unassigned
              michaeldg Michaël de groot
              Votes:
              1 Vote for this issue
              Watchers:
              2 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.