innobackupex-1.5.1 with "--no-lock" option


Usually innobackupex-1.5.1 needs to execute “FLUSH TABLES WITH READ LOCK” to lock to the whole MySQL server. But I don’t want to lock MySQL during backup. The xtrabackup command can backup InnoDB tables without locking, but it doesn’t copy .frm file to restore tables. So I have to backup .frm file separately.

innobackupex-1.5.1 with “–no-lock” option could backup the data without locking, but I’m not sure it is okay. About data consistency, Backup without lockgin is no proble because all tables are InnoDB. However I don’t know whether or not I copy .frm files without closing those tables using “FLUSH TABLES WITH READ LOCK”.

Could I use innobackupex with “–no-lock” if I’ll backup only InnoDB tables?



Yes, you can do that.

OK. Thanks, xaprb