Check MySQL Replication Status on Query Servers

Use the following procedure to check MySQL replication status on query servers:

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

# cd /opt/mysql/mysql/bin

# mysql -u root -p
Enter password:
<Query Server’s MySql root user password>
Check the replication status using the show slave status command (the status of the slave server is conveyed by the Slave_IO_Running and Slave_SQL_Running column values):
```
mysql> SHOW SLAVE STATUS \G;
```