Re: Adding a New Slave to a Live Replication Master

2003-11-21 Thread Mikael Fridh
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

Adding a New Slave to a Live Replication Master

2003-11-21 Thread Gabriel Ricard
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