[MDEV-33668] Adapt parallel slave's round-robin scheduling to XA events - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.6, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4, 11.5
Fix Version/s: 11.3.2, 10.6.18, 10.11.8, 11.0.6, 11.1.5, 11.2.4, 11.4.2
Component/s: Replication, XA
Labels:
None

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

MDEV-27512 Assertion `! thd->transaction_rollback_request' failed in rows_event_stmt_cleanup

Closed

relates to

MDEV-742 LP:803649 - Xa recovery failed on client disconnection

Closed

MDEV-21107 Assertion `!tmp_gco->next_gco || tmp_gco->last_sub_id > sub_id' failed in finish_event_group

Confirmed

split from

MDEV-31949 slow parallel replication of user xa

In Review

Activity

People

Assignee:: Andrei Elkin

Reporter:: Andrei Elkin

Votes:: 1 Vote for this issue

Watchers:: 9 Start watching this issue

Dates

Created:: 2024-03-13 14:45

Updated:: 4 hours ago

Resolved:: 2024-04-09 09:43

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.