# \[innobackupex with --no-lock\] replication MySQL

**URL:** <https://forums.percona.com/t/innobackupex-with-no-lock-replication-mysql/3124>\
**Category:** Percona XtraBackup\
**Created:** [November 27, 2013, 10:40am UTC](https://forums.percona.com/t/innobackupex-with-no-lock-replication-mysql/3124 "2013-11-27T10:40:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tdelnatte](https://avatars.discourse-cdn.com/v4/letter/t/edb3f5/32.png) [@tdelnatte](https://forums.percona.com/u/tdelnatte)\
**Post date:** [November 27, 2013, 10:40am UTC](https://forums.percona.com/t/innobackupex-with-no-lock-replication-mysql/3124/1 "2013-11-27T10:40:51Z")

</div>

I tried to perform a backup with --no-lock and still get binary log pos of xtrabackup\_logfile to initiate mysql replication.  
I tried to do exactly what is described in this post below but i didn’t manage to get binary log pos after the prepare step

[URL=“[Etsy Engineering | No more locks with Xtrabackup](http://codeascraft.com/2012/08/07/no-more-locks-with-xtrabackup/)”][http://codeascraft.com/2012/08/07/no...th-xtrabackup/[/URL]](http://codeascraft.com/2012/08/07/no...th-xtrabackup/%5B/URL%5D)

Is it possible?

Any way to perform a backup with no lock and still be able to resync master and slave?

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [November 28, 2013, 5:22am UTC](https://forums.percona.com/t/innobackupex-with-no-lock-replication-mysql/3124/2 "2013-11-28T05:22:40Z")

</div>

As [–no-lock](http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--no-lock) describes use this option if you don’t care backup binary log position so backup doesn’t contains xtrabackup\_binlog\_info file if backup is created with [–no-lock](http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--no-lock) option because [–no-lock](http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--no-lock) prevents FTWRL which is required to get consistent positions for binary log. If you are taking backup from master to provision new slave i suggest to do during offpeak time. This should help you regarding provisioning new slave [url][Percona XtraBackup](http://www.percona.com/doc/percona-xtrabackup/2.1/howtos/setting_up_replication.html%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![tdelnatte](https://avatars.discourse-cdn.com/v4/letter/t/edb3f5/32.png) [@tdelnatte](https://forums.percona.com/u/tdelnatte)\
**Post date:** [December 2, 2013, 5:49am UTC](https://forums.percona.com/t/innobackupex-with-no-lock-replication-mysql/3124/3 "2013-12-02T05:49:04Z")

</div>

It seems there is no workaround to do this without downtime ☹

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [December 3, 2013, 1:56am UTC](https://forums.percona.com/t/innobackupex-with-no-lock-replication-mysql/3124/4 "2013-12-03T01:56:45Z")

</div>

If all your database tables are InnoDB then surely no downtime because as i said it will only take FTWRL for very short time to copy .frm files. On the other hand if you using MyISAM tables then FTWRL blocks the all tables to copy .MYD, .MYI, .FRM files

---

<div class="post-metadata">

**Author:** ![tdelnatte](https://avatars.discourse-cdn.com/v4/letter/t/edb3f5/32.png) [@tdelnatte](https://forums.percona.com/u/tdelnatte)\
**Post date:** [December 3, 2013, 4:25am UTC](https://forums.percona.com/t/innobackupex-with-no-lock-replication-mysql/3124/5 "2013-12-03T04:25:26Z")

</div>

Oh sorry,

you are right.