MySQL Forums
Forum List  »  Replication

Re: change SLAVE options while it is running
Posted by: Aftab Khan
Date: September 03, 2012 01:41PM

>For exemple, how to change "replicate-ignore-table" without restart of mysql daemon?

It requires MySQL restart. However, there are some Slave options that can be changed without MySQL restart, e,g, master_password

STOP SLAVE; -- if replication was running
CHANGE MASTER TO MASTER_PASSWORD='new3cret';
START SLAVE; -- if you want to restart replicatio


http://dev.mysql.com/doc/refman/5.1/en/change-master-to.html

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: change SLAVE options while it is running
1015
September 03, 2012 01:41PM


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.