MHA实现mysql主从数据库手动切换的方法(7)

mysql> show slave status＼G;
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 10.1.1.231
                  Master_User: jpsync
                  Master_Port: 63306
                Connect_Retry: 60
              Master_Log_File: mysql-master-bin.000014
          Read_Master_Log_Pos: 120
               Relay_Log_File: compute-0-52-relay-bin.000005
                Relay_Log_Pos: 290
        Relay_Master_Log_File: mysql-master-bin.000014
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
 
mysql> show processlist;
+----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+------------------+
| Id | User        | Host      | db   | Command | Time | State                                                                       | Info             |
+----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+------------------+
|  1 | system user |           | NULL | Connect |   58 | Waiting for master to send event                                            | NULL             |
|  2 | system user |           | NULL | Connect |   58 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL             |
|  3 | root        | localhost | NULL | Query   |    0 | init                                                                        | show processlist |
+----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+------------------+
3 rows in set (0.00 sec)

希望本文所述对大家的MySQL数据库程序设计有所帮助。