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

system versioning with trx_id breaks when replicated

    XMLWordPrintable

Details

    Description

      if system versioning is done via innodb internal transaction identifiers, there is no way to replicate such table to have identical data on the slave.

      In SBR replication will work and replicated tables will be usable, but they'll have different transaction identifiers. in RBR it won't work at all. And one could not bootstrap the slave by copying tables over.

      All this, supposedly, can be fixed by using gtrid instead of innodb internal transaction ids. That is, by adding gtrid columns to the transaction registry table and storing gtrids in versioned tables.

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.