MySQL Forums
Forum List  »  Replication

Moving replication database servers.
Posted by: Andrew Poodle
Date: October 07, 2005 04:05AM

I'm having to physically move the master and slave servers. I just want to check my processes are correct, and won't cause any problems.

Slave: "Slave Stop"
Slave: "Show Slave Status"
Slave: Note down master log position (just in case)

master: Shutdown master database
master: shutdown box
master: move box

slave: Shutdown MysQL
slave: Shutdown box
Slave: move box

master: restart box
master: Check MySQL is back up and running.

slave: restart box
slave: check mySQL is running
slave: "show slave status" and check replication is running, if not, start replication manually.

hopfully all should be well.

My worry is that restarting the master database does some binlog flushing. I can't see anything in the documentation to say it does, but equally, I can't see anythiung to explicxitly say it doesn't.



Options: ReplyQuote

Written By
Moving replication database servers.
October 07, 2005 04:05AM

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.