How do I stop/start a MySQL Server in Replication

Hello,

I have just taken over some of our servers, 2 of which are in Replication mode. That is Server1 is Master to Server2 in Replication.

My question is what is (are) the MySQL command(s) to Stop & Start Server1?

From what I understand, it is the not the standard, or as simple as:
mysql start/stop
or
mysqld start

So how does one Stop and Start a server that is Master in a Replication process?

Best Regards,

if you just want to shut down the whole mysql server process on the slave server, then that is correct.

if you want to stop replication but leave the server running, see http://dev.mysql.com/doc/refman/5.1/en/replication-administration-pausing.html

Hi,

Actually I need to know what are the commands for Stopping and Starting the Master? and not the Slave.

Regards,

you need to define “stop the master”. do you just want to turn off mysql? do you want to stop replication? do you want to unconfigure replication?

Hi,

I want to Stop and Start replication on Master (mySQL) server?
And also Stop and Start the Master (mySQL) server?

Regards,