The Percona XtraBackup Documentation, Release 2.0.6 states: Percona XtraBackup is a hot backup utility that does not lock your database during the backup. However the documentation also states that it will execute “FLUSH TABLES WITH READ LOCK.” That certainly will lock the database. Arent these s…

Does Percona XtraBackup lock the database during the backup?

mirfan September 15, 2013, 2:57pm 4

This applies for .frm files and for non-innodb tables.

Topic		Replies	Views
XtraBackup Appears to Lock Percona XtraBackup	1	647	August 21, 2018
Write lock on tables when executing backup Percona XtraBackup	5	1121	October 16, 2013
About deadlock of FLUSH TABLES WITH READ LOCK in xtrabackup Percona XtraBackup	6	1081	April 9, 2018
Use --no-backup-locks or not Percona XtraBackup	2	806	October 4, 2023
Xtrabackup render the DB unreadable with locks even with no-lock option Percona XtraBackup percona	2	828	April 18, 2023