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

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.3.8
    • Fix Version/s: N/A
    • Component/s: Backup
    • Labels:
    • Environment:
      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. 10_2_14.log
          250 kB
        2. 10_3_8.log
          1.51 MB
        3. backup-DB.sh
          0.7 kB
        4. backup-mysql.sh
          0.3 kB
        5. my.cnf
          3 kB

          Issue Links

            Activity

              People

              • Assignee:
                wlad Vladislav Vaintroub
                Reporter:
                peterw17 Peter Warmer
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: