Start MySQL Replication on Query Servers

Use the following procedure to start 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>
Start MySQL replication:
When the replication operation resumes, the slave server should connect to the master and catch up on any updates that occurred since the replication operation was terminated.
mysql> start slave;
Verify that MySQL replication is running using the show slave status command (ensure the Slave_IO_Running and Slave_SQL_Running column values are set to Yes, and ensure that the log file has a name).
mysql> SHOW SLAVE STATUS \G;
Exit the MySQL command-line utility:
mysql> exit;