Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.3.8
-
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
Issue Links
- relates to
-
MDEV-15730 mariabackup: rename --stream=xbstream to --stream=mbstream
-
- Closed
-
Hello winstone,
because our servers were upgraded from 10_2_14 to 10_3_8, I don't have a 10_2_14 anymore. For 10_3_8 I get for the backup last night:
root@dbcluster02:/var/backup/DB/db02#du --summarize Tue/
1542557240 Tue/
and the current disk usage of the DB is:
root@dbcluster02:/var/backup/DB/db02#du --summarize /var/lib/mysql/
1551101564 /var/lib/mysql/