美文网首页
mysql slave 修改链接 master ip

mysql slave 修改链接 master ip

作者: 虚心的锄头 | 来源:发表于2019-11-07 11:37 被阅读0次
    mysql> STOP SLAVE;
    
    mysql> SHOW SLAVE STATUS\G
    *************************** 1. row ***************************
                 Slave_IO_State: Reconnecting after a failed master event read
                    Master_Host: 10.0.0.1
                    Master_User: replicate
                    Master_Port: 3306
                  Connect_Retry: 60
                Master_Log_File: mysql-bin.000005
            Read_Master_Log_Pos: 11622542
                 Relay_Log_File: mysqld-relay-bin.000074
                  Relay_Log_Pos: 11622679
          Relay_Master_Log_File: mysql-bin.000005
               Slave_IO_Running: No
              Slave_SQL_Running: Yes
                Replicate_Do_DB: 
            Replicate_Ignore_DB: mythconverg
             Replicate_Do_Table: 
         Replicate_Ignore_Table: 
        Replicate_Wild_Do_Table: 
    Replicate_Wild_Ignore_Table: 
                     Last_Errno: 0
                     Last_Error: 
                   Skip_Counter: 0
            Exec_Master_Log_Pos: 11622542
                Relay_Log_Space: 11622679
                Until_Condition: None
                 Until_Log_File: 
                  Until_Log_Pos: 0
             Master_SSL_Allowed: No
             Master_SSL_CA_File: 
             Master_SSL_CA_Path: 
                Master_SSL_Cert: 
              Master_SSL_Cipher: 
                 Master_SSL_Key: 
          Seconds_Behind_Master: NULL
    1 row in set (0.00 sec)
    
    mysql> CHANGE MASTER TO MASTER_HOST='192.168.1.1',MASTER_LOG_FILE='mysql-bin.000005', MASTER_LOG_POS=11622542;
    
    mysql> START SLAVE;
    
    

    相关文章

      网友评论

          本文标题:mysql slave 修改链接 master ip

          本文链接:https://www.haomeiwen.com/subject/gegmbctx.html