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 statements contradictory? I need to know if Percona XtraBackup will lock tables during backup? If yes, then I wouldnt be able to use this in production.
Our database consists only of InnoDB tables.