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 the already running slave instead.
If the machine is fast and you only have say 5 gigs of data, it shouldn't take
more than 5-10 minutes to copy it.
Mike
On Friday 21 November 2003 18.15, Gabriel Ricard wrote:
> 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 and then issue a LOAD DATA FROM MASTER command to pull in any
> existing data?
>
> Is there a recommended procedure for this?
>
> - Gabriel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
