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?

r4z0r September 13, 2013, 1:27pm 3

When do these restrictions apply? During the whole backup process or just the time when the non-innodb tables are being copied?

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	809	October 4, 2023
Xtrabackup render the DB unreadable with locks even with no-lock option Percona XtraBackup percona	2	828	April 18, 2023