If you use xtrabackup you can do this non-blocking, giving you a bit more
time. So first take an xtrabackup from the running master, rsync that to
the slaves and restore it there. It can even store the binlog position so
it becomes easy to start the slave replication after restoring the backup
on the master and let it catch up by itself.
On Mon, Sep 16, 2013 at 1:13 PM, nik600 <nik600@stripped> wrote:
> I'm looking at the fastes solution to re-sync a SLAVE node after a
> I have 300 databases with 80 GB of data, as i want to miminize the
> down-time on the master node i'd like to:
> 1) run a first rsync from master to slave
> 2) shut down the master
> 3) run a 2nd rsync
> 4) start the slave
> 5) start the master
> is this the correct way?
> can i simply lock all write command to the master at step 2 instead of
> shutting down it?
CEO / Founder OlinData <http://olindata.com/?src=wh_gapp> - Open Source
Training & Consulting
Check out our upcoming Drupal and Puppet