Hi all,
In looking at the 2.0 docs:
http://www.percona.com/doc/percona-xtrabackup/2.0/innobackupex/innobackupex_option_reference.html
The --no-lock option states the following:
Looking at the Zarafa docs:
http://doc.zarafa.com/7.1/Administrator_Manual/en-US/html-single/#_full_database_dump
We have the following:
I have absolutely noticed this “freezing” behavior when attempting to use innobackupex.
Here is a little background:
I currently have an active/passive (master/slave) MySQL 5.0 setup with all InnoDB tables. Generally speaking, I’d like to take backups off the slave and I don’t really care about the binary log in that case.
-
Is it “safe” to run innobackupex on the slave without “–no-lock” if I am just doing a general backup / incremental backup and not trying to populate a slave?
-
If I wanted to prepare a backup to populate a slave (where binary coordinates were vital), would I have to use mysqldump without --lock-tables as opposed to innobackupex, since the notes seem to indicate --no-lock may not provide “safe” binary coordinates?
Thanks!