MySQL的从库出现Slave_IO_Running: No(解决方法)
mysql replication 中slave机器上有两个关键的进程,死一个都不行, 一个是slave_sql_running, 一个是Slave_IO_Running, 一个负责与主机的io通信, 一个负责自己的slave mysql进程。
此次出现的问题,是因为服务器重启导致,先到主库
mysql> show master status; +------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+----------+--------------+------------------+ | mysql-bin.001570 | 1032669 | | | +------------------+----------+--------------+------------------+ 1 row in set (0.00 sec)
在到从库执行
mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> change master to Master_Log_File='mysql-bin.001570',Master_Log_Pos=1032669; Query OK, 0 rows affected (0.00 sec) mysql> start slave; Query OK, 0 rows affected (0.00 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.1.100 Master_User: slave Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.001570 Read_Master_Log_Pos: 1040630 Relay_Log_File: ucenter-slave-relay-bin.000002 Relay_Log_Pos: 8228 Relay_Master_Log_File: mysql-bin.001570 Slave_IO_Running: Yes Slave_SQL_Running: Yes
<< 上一篇
下一篇 >>
网友留言(0 条)