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

Adapt parallel slave's round-robin scheduling to XA events

Details

    Description

      This ticket offers an alternative to MDEV-33667 solution for improving parallel slave performance of XA transaction load.
      Round-robin distribution is mingled with assigning XA-"COMPLETE" events to the same
      slave workers that currently may be processing respective XA-PREPARE parts.

      The algorithm tries to reach fair distribution but it can't provide the parallelism of
      XA-PREPARE with XA-COMMIT (ROLLBACK).

      Currently knielsen_xa_sched_minimal_fix branch contains such solution.

      10.6 Rebase branch: bb-10.6-MDEV-33668
      https://github.com/MariaDB/server/commits/bb-10.6-MDEV-33668/

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27512 Assertion `! thd->transaction_rollback_request' failed in rows_event_stmt_cleanup

          • Critical - Crashes, loss of data, severe memory leak.
          • 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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21107 Assertion `!tmp_gco->next_gco || tmp_gco->last_sub_id > sub_id' failed in finish_event_group

          • Critical - Crashes, loss of data, severe memory leak.
          • Confirmed
          split from

          New Feature - A new feature of the product, which has yet to be developed. MDEV-31949 slow parallel replication of user xa

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

          Activity

            Ascending order - Click to sort in descending order
            Elkin Andrei Elkin created issue -
            Elkin Andrei Elkin made changes -
            Field Original Value New Value
            Assignee Andrei Elkin [ elkin ]
            Elkin Andrei Elkin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            Elkin Andrei Elkin made changes -
            Status In Progress [ 3 ] In Review [ 10002 ]
            Roel Roel Van de Paar made changes -
            Description This ticket offers an alternative to MDEV-33667 solution for improving parallel slave performance of XA transaction load.
            Round-robin distribution is mingled with assigning XA-"COMPLETE" events to the same
            slave workers that currently may be processing respective XA-PREPARE parts.

            The algorithm tries to reach fair distribution but it can't provide the parallelism of
            XA-PREPARE with XA-COMMIT (ROLLBACK).

            Currently knielsen_xa_sched_minimal_fix branch contains such solution.             		This ticket offers an alternative to MDEV-33667 solution for improving parallel slave performance of XA transaction load.
            Round-robin distribution is mingled with assigning XA-"COMPLETE" events to the same
            slave workers that currently may be processing respective XA-PREPARE parts.

            The algorithm tries to reach fair distribution but it can't provide the parallelism of
            XA-PREPARE with XA-COMMIT (ROLLBACK).

            Currently knielsen_xa_sched_minimal_fix branch contains such solution.

            Current branch: bb-10.6-MDEV-33668
            Roel Roel Van de Paar made changes -
            Description This ticket offers an alternative to MDEV-33667 solution for improving parallel slave performance of XA transaction load.
            Round-robin distribution is mingled with assigning XA-"COMPLETE" events to the same
            slave workers that currently may be processing respective XA-PREPARE parts.

            The algorithm tries to reach fair distribution but it can't provide the parallelism of
            XA-PREPARE with XA-COMMIT (ROLLBACK).

            Currently knielsen_xa_sched_minimal_fix branch contains such solution.

            Current branch: bb-10.6-MDEV-33668             		This ticket offers an alternative to MDEV-33667 solution for improving parallel slave performance of XA transaction load.
            Round-robin distribution is mingled with assigning XA-"COMPLETE" events to the same
            slave workers that currently may be processing respective XA-PREPARE parts.

            The algorithm tries to reach fair distribution but it can't provide the parallelism of
            XA-PREPARE with XA-COMMIT (ROLLBACK).

            Currently knielsen_xa_sched_minimal_fix branch contains such solution.

            Current branch: {{bb-10.6-MDEV\-33668}}
            Roel Roel Van de Paar made changes -
            Description This ticket offers an alternative to MDEV-33667 solution for improving parallel slave performance of XA transaction load.
            Round-robin distribution is mingled with assigning XA-"COMPLETE" events to the same
            slave workers that currently may be processing respective XA-PREPARE parts.

            The algorithm tries to reach fair distribution but it can't provide the parallelism of
            XA-PREPARE with XA-COMMIT (ROLLBACK).

            Currently knielsen_xa_sched_minimal_fix branch contains such solution.

            Current branch: {{bb-10.6-MDEV\-33668}}             		This ticket offers an alternative to MDEV-33667 solution for improving parallel slave performance of XA transaction load.
            Round-robin distribution is mingled with assigning XA-"COMPLETE" events to the same
            slave workers that currently may be processing respective XA-PREPARE parts.

            The algorithm tries to reach fair distribution but it can't provide the parallelism of
            XA-PREPARE with XA-COMMIT (ROLLBACK).

            Currently knielsen_xa_sched_minimal_fix branch contains such solution.

            10.6 Rebase branch: {{bb-10.6-MDEV\-33668}}
            Roel Roel Van de Paar made changes -
            Roel Roel Van de Paar made changes -
            Roel Roel Van de Paar made changes -
            Component/s XA [ 12400 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 11.3 [ 28565 ]
            Fix Version/s 11.4 [ 29301 ]
            Affects Version/s 10.4 [ 22408 ]
            Affects Version/s 11.3 [ 28565 ]
            Affects Version/s 11.4 [ 29301 ]
            Affects Version/s 11.5 [ 29506 ]
            Roel Roel Van de Paar made changes -
            Affects Version/s 10.4 [ 22408 ]
            Roel Roel Van de Paar made changes -
            Fix Version/s 10.4 [ 22408 ]
            Roel Roel Van de Paar made changes -
            Affects Version/s 10.5 [ 23123 ]
            Roel Roel Van de Paar made changes -
            Fix Version/s 10.5 [ 23123 ]
            Roel Roel Van de Paar made changes -
            Description This ticket offers an alternative to MDEV-33667 solution for improving parallel slave performance of XA transaction load.
            Round-robin distribution is mingled with assigning XA-"COMPLETE" events to the same
            slave workers that currently may be processing respective XA-PREPARE parts.

            The algorithm tries to reach fair distribution but it can't provide the parallelism of
            XA-PREPARE with XA-COMMIT (ROLLBACK).

            Currently knielsen_xa_sched_minimal_fix branch contains such solution.

            10.6 Rebase branch: {{bb-10.6-MDEV\-33668}}             		This ticket offers an alternative to MDEV-33667 solution for improving parallel slave performance of XA transaction load.
            Round-robin distribution is mingled with assigning XA-"COMPLETE" events to the same
            slave workers that currently may be processing respective XA-PREPARE parts.

            The algorithm tries to reach fair distribution but it can't provide the parallelism of
            XA-PREPARE with XA-COMMIT (ROLLBACK).

            Currently knielsen_xa_sched_minimal_fix branch contains such solution.

            10.6 Rebase branch: {{bb-10.6-MDEV\-33668}}
            https://github.com/MariaDB/server/commits/bb-10.6-MDEV-33668/
            ralf.gebhardt Ralf Gebhardt made changes -
            Elkin Andrei Elkin made changes -
            Assignee Andrei Elkin [ elkin ] Kristian Nielsen [ knielsen ]
            Roel Roel Van de Paar made changes -
            Roel Roel Van de Paar made changes -
            monty Michael Widenius made changes -
            Assignee Kristian Nielsen [ knielsen ] Andrei Elkin [ elkin ]
            Roel Roel Van de Paar made changes -
            Elkin Andrei Elkin made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            Elkin Andrei Elkin made changes -
            Fix Version/s 10.6.18 [ 29627 ]
            Fix Version/s 10.11.8 [ 29630 ]
            Fix Version/s 11.0.6 [ 29628 ]
            Fix Version/s 11.1.5 [ 29629 ]
            Fix Version/s 11.2.4 [ 29631 ]
            Fix Version/s 11.4.2 [ 29633 ]
            Fix Version/s 11.3.2 [ 29522 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.11 [ 27614 ]
            Fix Version/s 11.0 [ 28320 ]
            Fix Version/s 11.1 [ 28549 ]
            Fix Version/s 11.3 [ 28565 ]
            Fix Version/s 11.2 [ 28603 ]
            Fix Version/s 11.4 [ 29301 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 202479

            People

              Elkin Andrei Elkin
              Elkin Andrei Elkin
              Votes:
              1 Vote for this issue
              Watchers:
              9 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.