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

change master to master_host='10.1.1.231',master_port=63306,master_user='jpsync',
master_password='jppasswd', master_log_file='mysql-master-bin.000013',master_log_pos=120;
 
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.000013
          Read_Master_Log_Pos: 120
               Relay_Log_File: compute-0-52-relay-bin.000002
                Relay_Log_Pos: 290
        Relay_Master_Log_File: mysql-master-bin.000013
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes

复制代码 代码如下: