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

MariaBackup very slow after upgrading from 10.2.14 to 10.3.8

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.3.8
    • N/A
    • Backup
    • Fedora Server 27, Galera cluster with 3 nodes, DB size ~ 1.4TB

    Description

      We have a 3 node Galera cluster and a separate backup server where we run MariaBackup. The backup worked well with version 10.2.14. After upgrading the 4 servers to MariaDB / MariaBackup 10.3.8 the backup is much slower (as you can see in the attached log files).
      On the backup server we run this from a script:

      /usr/bin/ssh backup@$IP "/usr/bin/sudo /usr/local/bin/backup-mysql.sh" | mbstream -x -C $BACKUPDIR/$1/$WEEKDAY

      /usr/bin/mariabackup --host=$IP --user=backup --password=xxxx --use-memory=10G --prepare --target-dir $BACKUPDIR/$1/$WEEKDAY

      and this is called on the DB server:

      /usr/bin/mariabackup --backup --use-memory=10G --galera-info --ftwrl-wait-threshold=40 --ftwrl-wait-query-type=all --ftwrl-wait-timeout=180 --kill-long-queries-timeout=20 --kill-long-query-type=all --user=backup --password=xxxx --stream=xbstream --target-dir /var/tmp

      Attachments

        1. my.cnf
          3 kB
        2. backup-mysql.sh
          0.3 kB
        3. backup-DB.sh
          0.7 kB
        4. 10_3_8.log
          1.51 MB
        5. 10_2_14.log
          250 kB

        Issue Links

          Activity

            People

              wlad Vladislav Vaintroub
              peterw17 Peter Warmer
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.