Xtrabackup - High Seconds Behind Master while backing up

Hello,
I’m running a MySQL 8.0.28, which has a master and a slave, and the Xtrabackup v. 8.0.35-30. The backups are being performed on the slave. The problem is that while the backup is being made, the replication seems to stop, causing a high value for seconds behind master. I have others environments with the same versions, running the exact same backup script and this behavior does not occur on them.

How can I identify what is causing this behavior?

Hi @tpiontk ,

You can check if the following configuration is being used there (–safe-slave-backup):

1 Like

Hi @tpiontk,

Also, if you can share the xtrabackup command you are using for taking backups, it will help us understand what may cause the issue with replication being stuck.

Regards,
Denis Subbota.

The xtrabackup running is:

/bin/xtrabackup --defaults-file=/etc/mysql_backup.conf --backup --datadir=/var/lib/mysql/datadir --target-dir=/backup/xtrabackup --socket=/var/lib/mysql/mysql.sock --user=my_user --password=***** --compress --parallel=2 2>> /var/log/xtrabackup.log

Sorry about the late reply. As I posted in a comment below, we do not use this clause.