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

point in time backup with parallel mariadb-dump --dir

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 11.8.2
    • None
    • Backup
    • None

    Description

      Is there a way to take a point in time backup when using:

      mariadb-dump --lock-tables --all-databases --dir=/dumpdir --parallel=4

      e.g. combining the above with:

      --master-data=2 --dump-slave=2 --gtid

      and if so, where would I find the binlog file and pos or the gtid value? Afiak it is not documented.

      it would be great if an info file could be generated analog to mariadb-backup but I could not find it.

      Also my guess is --single-transaction would be incompatible with parallel selects, hence the --lock-tables in above statement, but this is nog documented.

      Attachments

        Issue Links

          Activity

            People

              Deepthi ES Deepthi Eranti Sreenivas
              Betel Michiel
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.25h
                  0.25h

                  Git Integration

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