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

          relates to

          Task - A task that needs to be done. MDEV-11657 Cross-engine transaction metadata

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-13236 Document MDEV-12179 (Per-engine mysql.gtid_slave_pos tables)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34778 Inconsistent Seconds_Behind_Master after slave stop+start (rpl.rpl_old_master sporadic failure)

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            View 5 older comments
            psergei Sergei Petrunia added a comment -

            knielsen, thanks for clarification

            psergei Sergei Petrunia added a comment - knielsen , thanks for clarification
            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 .

            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 .
            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

            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
            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.

            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:

            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.