title: Setting up MySql Master-Slave Replication without locking?
body: <p>I'm trying to set up replication for a database roughly 80gbs in size. From all the documentation I read it seems like when you do the inital mysqldump to get the data to the slave you have to do a global </p>
  
  <pre><code>FLUSH TABLES WITH READ LOCK
  </code></pre>
  
  <p>Then record the binlog position after the dump. Is there anyway to set up replication without locking the database? Or at least do table-level locking?</p>