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
Subject
Views
Written By
Posted
1460
September 03, 2012 09:25AM
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.