1

while setting up the replication I accidentally did the 'CHANGE MASTER TO' on the master server instead the slave.

When I noticed the mistake I just did a 'STOP SLAVE' on the master and setup the slave then correctly, replication is working.

I am just wondering if there is a need/way to remove this 'change master to' on the master server again, I havent found anything in the Documentation and 'reset master' seems to be something else.

I can't see any issues currently, so maybe I don't need to bother about it. If possible I'd stil; like to know how to correct it.

Thanks

1

In earlier versions of MySQL, you would run this on the Master

STOP SLAVE;
CHANGE MASTER TO master_host = '';

and restart mysqld.

For MySQL 5.5/5.6, you would run this on the Master

STOP SLAVE;
RESET SLAVE ALL;

MySQL restart not required

For more details on this, please read Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL) from PERCONA MYSQL PERFORMANCE BLOG

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.