GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Hello,

    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?

    Regards,

    Hiroshi

  • #2
    Yes, you can do that.

    Comment


    • #3
      OK. Thanks, xaprb

      Regards,

      hiroshi

      Comment

      Working...
      X