MySQL Forums
Forum List  »  Replication

Have a master-slave. How to setup a 'new' slave.
Posted by: krik s
Date: May 04, 2012 01:03AM

Hi, I need help in setting up a new slave. I currently have a master-slave setup and the tables use both InnoDB and MyISAM, taking dump would lock the tables, I don't want to lock the tables on the master (which would result in the application freezing). I believe I would need to take the dump with --master-data flag set, can I do this on the slave (by enabling log-bin on the slave)? I have the 'log-bin' flag off until now on the Slave. Can someone suggest a way for me to setup this new slave without outage of my application?

Thanks,
Krik

Options: ReplyQuote


Subject
Views
Written By
Posted
Have a master-slave. How to setup a 'new' slave.
1508
May 04, 2012 01:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.