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

Per-engine mysql.gtid_slave_pos tables

Details

    • 10.3.1-1

    Description

      Implement that server reads/updates the GTID position using multiple tables
      mysql.gtid_slave_pos_XXX, each using a different storage engine. Replicated
      transactions update the version of the table in the same engine, if
      available. This avoids the overhead of cross-engine transactions on servers
      where multiple storage engines are in use at the same time (but not in the
      same transactions).

      See mailing list thread: https://lists.launchpad.net/maria-developers/msg10453.html

      Attachments

        Issue Links

          Activity

            knielsen, thanks for clarification

            psergei Sergei Petrunia added a comment - knielsen , thanks for clarification

            Ok I have no issues with the patch (Review Done), except the question of how to package this, which I have described here: https://lists.launchpad.net/maria-developers/msg10779.html .

            psergei Sergei Petrunia added a comment - Ok I have no issues with the patch (Review Done), except the question of how to package this, which I have described here: https://lists.launchpad.net/maria-developers/msg10779.html .

            Merged the code to MariaDB 10.3 (not automatic but nothing complex): https://github.com/MariaDB/server/tree/bb-10.3-mdev12179

            psergei Sergei Petrunia added a comment - Merged the code to MariaDB 10.3 (not automatic but nothing complex): https://github.com/MariaDB/server/tree/bb-10.3-mdev12179

            Pushed to 10.3.1.

            For now, the default for --gtid-pos-auto-engines is empty. This can be easily changed if desired, just update the value in sql/mysqld.cc.

            knielsen Kristian Nielsen added a comment - Pushed to 10.3.1. For now, the default for --gtid-pos-auto-engines is empty. This can be easily changed if desired, just update the value in sql/mysqld.cc.
            jeanfrancois.gagne Jean-François Gagné added a comment - Leaving some links about this work here: http://kristiannielsen.livejournal.com/19223.html https://jfg-mysql.blogspot.com/2017/05/better-replication-with-many-storage-engine.html

            People

              knielsen Kristian Nielsen
              knielsen Kristian Nielsen
              Votes:
              1 Vote for this issue
              Watchers:
              10 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.