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

slow parallel replication of user xa

    XMLWordPrintable

Details

    • New Feature
    • Status: In Review (View Workflow)
    • Critical
    • Resolution: Unresolved
    • ROADMAP
    • Replication
    • None

    Description

      With some type of load, such as one statement "light" transactions, the user xa may perform much poorer on the optimistic parallel slave than an equivalent normal - BEGIN..COMMIT - load.

      This ticket aims at fixing the slowness while the XA high-availability is to be preserved.

      The whole work is arranged in three parts:
      I. refactoring of the user xa binary logging to facilitate slave side parallel execution
      MDEV-32830;
      II. the slave side change of the parallel scheduler to apply Round-Robin distribution
      for the user XA transactions.
      III. optimize Innodb to not flush to disk at binlog-coordinated ordered commit by the user XA

      There is also associate piece of
      IV. to provide crash-recovery in MDEV-33168, MDEV-21777 that require the parts I and III.

      Attachments

        Issue Links

          Activity

            People

              knielsen Kristian Nielsen
              Elkin Andrei Elkin
              Votes:
              1 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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