HP OSMS Blueprint: Database Server on HP Server Platforms with MySQL and RHEL5

Monitoring Replication Status
1. Run the following command on the master server to display the status:
mysql> show master status\G
The file name and position of the bin log file that the master server is using are displayed:
*************************** 1. row ***************************
File: mysql-bin.000003
Position: 98
Binlog_Do_DB:
Binlog_Ignore_DB:
1 row in set (0.00 sec)
2. Run the following command on the master server to get information about slave servers
that are connecting to the master server:
mysql> show processlist\G
The following data is displayed:
*************************** 1. row ***************************
Id: 32
User: osmusr
Host: slave-1.test:32798
db: NULL
Command: Binlog Dump
Time: 5740
State: Has sent all binlog to slave; waiting for binlog to be updated
Info: NULL
*************************** 2. row ***************************
Id: 33
User: osmusr
Host: slave-2.test:32944
db: NULL
Command: Binlog Dump
Time: 2150
State: Has sent all binlog to slave; waiting for binlog to be updated
Info: NULL
*************************** 3. row ***************************
Id: 34
User: root
Host: localhost
db: NULL
Command: Query
Time: State: NULL
Info: show processlist
3 rows in set (0.00 sec)
The output shows that two slave servers, slave-1.test and slave-2.test, have
connected to the master server, and the master server has sent all the binary log data to both
slave servers and they are both up to date.
3. To show the status of the slave server, run the following command on the master server
mysql> show slave status\G
The master server information for this slave server and its status are displayed. If the slave
server has processed all updates from the binary log and is up to date with the master server,
the values of Master_Log_File and Read_Master_Log_Pos in the output are consistent
with the output of show master status on the master server from step 1.
20