龙空技术网

mysql slave 修改链接 master ip

隔壁说故事 118

前言:

现在各位老铁们对“mysqlslave切换master”大致比较关怀,姐妹们都想要知道一些“mysqlslave切换master”的相关资讯。那么小编同时在网摘上网罗了一些关于“mysqlslave切换master””的相关文章,希望同学们能喜欢,大家一起来学习一下吧!


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: NULL1 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;


标签: #mysqlslave切换master