Currently LOAD DATA FROM MASTER "is subject to the following conditions:
* It works only with MyISAM tables.
* It acquires a global read lock on the master while taking the snapshot,
which prevents updates on the master during the load operation. "
What I would do is take a snapshot from
I've got two database servers in production, one of which is a master
for a handful of tables and the other is a slave for these few tables.
I want to add an additional slave server without taking down the master
to create a snapshot. Is it possible to just setup the replication for
the slave a