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

Lag Free Alter On Slave

Details

    Description

      Desc:- This will split Alter into 2 different commits. START ALTER and COMMIT
      /ROLLBACK ALTER , Start Alter will be written in binlog as soon as we get the
      locks for the table, alter will proceeds as usual and at the time of writing
      binlog if alter is successful we will write COMMIT Alter other wise ROLLBACK
      Alter.

      Implementation details are in develop list
      https://lists.launchpad.net/maria-developers/msg12067.html

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33057 alter table form s3 to different engine on leader break replicas with binlog_alter_two_phase;

          • Major - Major loss of function.
          • Open

          Technical task - A technical task. MDEV-35431 my_snprintf fixes for 10.11+

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35474 Start Alter GTID Error Message Can Use Wrong Server_Id

          • Major - Major loss of function.
          • In Review

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35665 Potential Buffer Overrun in Gtid_log_event::write()

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27528 Cluster nodes become unstable when a transaction is replicated through Async replication from Galera Primary node

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

          Task - A task that needs to be done. MDEV-27373 Q1 2022 release merge

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-742 LP:803649 - Xa recovery failed on client disconnection

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

          Task - A task that needs to be done. MDEV-16223 Background ADD INDEX

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16281 Implement parallel CREATE INDEX, ALTER TABLE, or bulk load

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-16329 Engine-independent online ALTER TABLE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Task - A task that needs to be done. MDEV-17567 Atomic DDL

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

          Task - A task that needs to be done. MDEV-21742 Add recovery to MDEV-11675 and handle corner cases

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27528 Cluster nodes become unstable when a transaction is replicated through Async replication from Galera Primary node

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-7502 Automatic provisioning of slave

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22777 Assertion `thd->rgi_slave' failed in process_commit_alter / process_rollback_alter

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22985 Assertion `!(thd->rgi_slave && thd->rgi_slave->did_mark_start_commit)' failed in ha_rollback_trans

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27349 ASAN use-after-poison in Query_log_event::Query_log_event/THD::binlog_query

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27628 Lag free ALTER statement breaks replication when executing binlog_alter_two_phase = 1,0 dynamically

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

          Page Loading...

          Page Loading...

          Page Loading...

          Activity

            Ascending order - Click to sort in descending order
            View 6 older comments
            Elkin Andrei Elkin added a comment -

            The about to be created preview branch misses out FTWRL fixes that we've discussed today
            and it's just too late night for me to complete with them into the branch.
            This will be done tomorrow.

            Elkin Andrei Elkin added a comment - The about to be created preview branch misses out FTWRL fixes that we've discussed today and it's just too late night for me to complete with them into the branch. This will be done tomorrow.
            bnestere Brandon Nesterenko added a comment -

            I approve the current patch c592a5e. Note that it will still need the FTWRL fixes.

            bnestere Brandon Nesterenko added a comment - I approve the current patch c592a5e . Note that it will still need the FTWRL fixes.
            Elkin Andrei Elkin added a comment -

            Approving on the behalf of bnestere.

            Elkin Andrei Elkin added a comment - Approving on the behalf of bnestere .
            bnestere Brandon Nesterenko added a comment -

            Confirmed Andrei's approval on my behalf, I had to step away momentarily

            bnestere Brandon Nesterenko added a comment - Confirmed Andrei's approval on my behalf, I had to step away momentarily
            alice Alice Sherepa added a comment -

            I think it's fine to push the feature into 10.8.

            alice Alice Sherepa added a comment - I think it's fine to push the feature into 10.8.

            People

              Elkin Andrei Elkin
              sachin.setiya.007 Sachin Setiya (Inactive)
              Votes:
              4 Vote for this issue
              Watchers:
              20 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.