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
Why xtrabackup doesn't need "flush tables with read lock"? Percona XtraBackup	1	1398	June 30, 2015
innobackupex-1.5.1 with "--no-lock" option Percona XtraBackup	2	605	December 16, 2010
Tables locked while incrementel backup Percona XtraBackup	2	525	March 6, 2015
Write lock on tables when executing backup Percona XtraBackup	5	1121	October 16, 2013
Avoiding FLUSH TABLES during backup creation Percona XtraBackup	6	1766	December 3, 2021