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

FULL_NODUP mode for binlog_row_image

Details

    Description

      With FULL_NODUP mode, all columns are included in before image, but only updated columns are included in after image for UPDATE. While all columns are included in the after image for INSERT.

      FULL_NODUP is for replacing FULL mode. It includes all data of the before and after image as FULL mode, but it uses less storage, especially in the case that only a few columns are updated.

      This Jira is to track the contribution by Alibaba (https://github.com/MariaDB/server/pull/2803)

      (Note that originally the MDEV was referring to the original Alibaba option, FULL_DIFFERENT. This was changed to FULL_NODUP to reflect the option implemented in MariaDB).

      Attachments

        Issue Links

          Activity

            TheLinuxJedi Andrew Hutchings (Inactive) created issue -
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Field Original Value New Value
            Assignee Andrei Elkin [ elkin ]
            serg Sergei Golubchik made changes -
            Assignee Andrei Elkin [ elkin ] Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Andrei Elkin [ elkin ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            Elkin Andrei Elkin made changes -
            Assignee Andrei Elkin [ elkin ] Andrew Hutchings [ JIRAUSER52179 ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Fix Version/s 11.4.1 [ 29523 ]
            Fix Version/s 11.4 [ 29301 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Assignee Andrew Hutchings [ JIRAUSER52179 ] Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            Fix Version/s 11.4 [ 29301 ]
            Fix Version/s 11.4.1 [ 29523 ]
            elenst Elena Stepanova made changes -
            Component/s Replication [ 10100 ]
            Assignee Elena Stepanova [ elenst ] Roel Van de Paar [ roel ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Issue Type Task [ 3 ] New Feature [ 2 ]
            serg Sergei Golubchik made changes -
            Summary Add FULL_DIFFERENT mode for binlog_row_image FULL_NODUP mode for binlog_row_image
            ramesh Ramesh Sivaraman made changes -
            Roel Roel Van de Paar made changes -
            Assignee Roel Van de Paar [ roel ] Ramesh Sivaraman [ JIRAUSER48189 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Preview_11.4
            ramesh Ramesh Sivaraman made changes -
            Assignee Ramesh Sivaraman [ JIRAUSER48189 ] Andrew Hutchings [ JIRAUSER52179 ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Fix Version/s 11.4.1 [ 29523 ]
            Fix Version/s 11.4 [ 29301 ]
            Resolution Done [ 10200 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            monty Michael Widenius made changes -
            Description With FULL_DIFFERENT mode, all columns are included in before image, but only updated columns are included in after image for UPDATE. While all columns are included in the after image for INSERT.

            FULL_DIFFERENT is for replacing FULL mode. It includes all data of the before and after image as FULL mode, but it uses less storage, especially in the case that only a few columns are updated.

            This Jira is to track the contribution by Alibaba (https://github.com/MariaDB/server/pull/2803)
            With FULL_NODUP mode, all columns are included in before image, but only updated columns are included in after image for UPDATE. While all columns are included in the after image for INSERT.

            FULL_NODUP is for replacing FULL mode. It includes all data of the before and after image as FULL mode, but it uses less storage, especially in the case that only a few columns are updated.

            This Jira is to track the contribution by Alibaba (https://github.com/MariaDB/server/pull/2803)

            (Note that originally the MDEV was referring to the original Alibaba option, FULL_DIFFERENT. This was changed to FULL_NODUP to reflect the option implemented in MariaDB).
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -

            People

              TheLinuxJedi Andrew Hutchings (Inactive)
              TheLinuxJedi Andrew Hutchings (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.