thanks for the replies, unfortunately for me, we are still using v5.1.
i will try Andy's suggestion. thanks again!
On Mon, Apr 2, 2012 at 2:53 AM, Neil Armitage <neil@stripped> wrote:
> if you are running 5.5.3 or higher you could use --dump-slave on your
> mysqldump command line, it works like --master-data when cloning from a
> On 1 April 2012 17:54, nhadie ramos <nhadie@stripped> wrote:
>> I currently have a replication setup with master and 1 slave. i would
>> like to add one more slave into the setup.
>> is it possible if i lock the slave tables, show slave status and get
>> Relay_Log_Pos and Relay_Master_Log_File. and create
>> a snapshot. once done, use the created snapshot to the new slave and
>> start replication with the values i got from the slave?
>> Reason i would like to do this is because i don't want to lock tables
>> on the master.
>> MySQL Replication Mailing List
>> For list archives: http://lists.mysql.com/replication
>> To unsubscribe: http://lists.mysql.com/replication