MySQL 相关项目
搭建了个 主从 show slave status; 显示两个 YES, 但是数据就是不同步，Read_Master_log_pos 也不会发生变化
这是主的日志，从上没有错误日志
2019-03-23T05:36:45.018407Z 40439 [Note] While initializing dump thread for slave with UUID <8d15310a-4d29-11e9-865c-000c2981d89e>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(39466).
2019-03-23T05:36:45.018637Z 40439 [Note] Start binlog_dump to master_thread_id(40439) slave_server(2), pos(mysql-bin.000031, 7823661)
2019-03-23T05:38:36.545521Z 38520 [Note] Aborted connection 38520 to db: 'unconnected' user: 'repl' host: '10.0.0.8' (Failed on my_net_write())
主 show processlist; 状态一直会显示 Sending to client
44547 repl 10.0.0.8:1696 Binlog Dump 437 Sending to client
目前两台服务器可以用 mysql -h 互相进入控制台
Select Language