Hi, I am currently doing a case study regarding the usage of xtrabackup. When I am executing the backup it seems that reading from the tables is possible, but when the system tries to execute writes to the tables it seems that it is not allowed for a lock is currently on-going. Can anyone enlight…

Write lock on tables when executing backup

mixa October 11, 2013, 5:08am 2

Assuming that all tables are InnoDB:
Do you see any errors trying to write to DB? What in error-log?
Can you paste here output?

Topic		Replies	Views
innobackupex-1.5.1 with "--no-lock" option Percona XtraBackup	2	600	December 16, 2010
Does Percona XtraBackup lock the database during the backup? Percona XtraBackup	3	8148	September 15, 2013
Backup is locking InnoDB tables Percona XtraBackup	1	1380	July 10, 2014
innobackupex on MyISAM dbs only, locking of innodb Percona XtraBackup	0	452	May 4, 2012
Xtrabackup render the DB unreadable with locks even with no-lock option Percona XtraBackup percona	2	824	April 18, 2023