About deadlock of FLUSH TABLES WITH READ LOCK in xtrabackup

MySQL & MariaDB Percona XtraBackup
1

I am using Xtrabackup.
percona-xtrabackup-24-2.4.8-1.el6.x86_64

Is there a backup method that does not use FLUSH TABLES WITH READ LOCK ?
I am using slave and multithread slave. A deadlock bug may occur.

[url]MySQL Bugs: #87489: MTS ordered commit may cause deadlock with "FLUSH TABLES WITH READ LOCK"of slave

Please tell me the way to avoid this bug.

2

Xtrabackup’s --backup-locks is enabled by default.
Do not lock Innodb’s DML?

–ftwrl-wait-timeout=SECONDS
xtrabackup will automatically use Backup Locks as a lightweight alternative to FLUSH TABLES WITH READ LOCK to copy non-InnoDB data to avoid blocking DML queries that modify InnoDB tables.

3

I am using MySQL Community Edition.

4

Hello there can I just check - are you actually encountering this bug or are you just trying to make sure that you don’t encounter it in the future?
Thanks!

5

Hello.

I encountered this bug with mysqldump.
I am checking if I encounter the same bug with xtrabackup.
However, I think that using - safe - slave - backup option will not encounter. is it right?

6

Hi Yuji Fujihara

If you want to avoid locks then you should examine --no-lock [url]https://www.percona.com/doc/percona-xtrabackup/LATEST/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex-no-lock[/url]
But likely what you should work towards is --safe-slave-backup [url]https://www.percona.com/doc/percona-xtrabackup/LATEST/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex-safe-slave-backup[/url]

7

Thanks you!