Stop MySQL Replication on Query Servers

Use the following procedure to stop MySQL replication on the query server:

Start the MySQL command-line utility on the query server:

# cd /opt/mysql/mysql/bin

# mysql -u root -p
Enter password:
<Query Server’s MySql root user password>
Stop MySQL replication: (When replication is off, the slave server data is not updated and is not kept in synchronization with the master server.)
mysql> stop slave;
Verify that MySQL replication is no longer running using the show slave status command (ensure the Slave_IO_Running and Slave_SQL_Running column values are set to No).
mysql> SHOW SLAVE STATUS \G;
Exit the MySQL command-line utility:
mysql> exit;