Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.18
-
None
-
Debian 10.1
Description
Hello
We are trying to make a backup to setup one more slave, and we are using the `mariabackup` for this. We do not have enough space on the first slave server, so we are using a streaming (xbstream) backup to second slave. The database is about 1.5TB.
The problem is: the backup process starts without problems. But after some hours the backup speed reduced hundreds of times. It may takes days!
To exclude problems from the `mbstream` side, we connected the NFS share and started up without xbstream. And we saw the same picture:
The first backup was started with the command:
mariabackup --backup --slave-info --safe-slave-backup --user=root --target-dir=/var/lib/mysql-nfs --rsync --parallel=8 2> dump-nfs.log
|
When we found that the rate has fallen, we restart the process with some small changes:
mariabackup --backup --slave-info --safe-slave-backup --innodb_checksum_algorithm=innodb --user=root --target-dir=/var/lib/mysql-nfs --rsync --parallel=8 2> dump-nfs.log
|
As you can see, the backup process begins at a good speed, but after a while the speed drops a hundred times.
May it be related to the InnoDB table compression, which we are using? How can we avoid this behavior?