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

Parallel replication does not account for multiple databases

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Replication
    • None

    Description

      In a situation where there are multiple databases on a single MariaDB server, a slave connected to the master will not apply statements from separate databases in parallel. Normally, a transaction will only affect a single database; even if it affects a large number of tables, all of those tables will still be in the same DB. Therefore, it seems like a singularly obvious optimization to parallel replication for updates to separate databases to be applied simultaneously when possible (with, if necessary, safeguards to ensure that transactions which do affect multiple databases block subsequent transactions to any of the affected databases so as not to apply updates out of order).

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            Soltis Kai
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.