blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

Last_IO_Errno: 1129
Last_IO_Error: error connecting to master 'slavetest@xxx.xxx.xxx.xx:6612' - retry-time: 60 retries: 1 message: Host 'xxx.xxx.xxx.xx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

执行: mysqladmin  -uroot  -p  flush-hosts


跳过1次

stop slave;
set global sql_slave_skip_counter=1;
start slave;
show slave status G;


set global slave-skip-errors=1062;
stop slave;
start slave;

set global slave-skip-errors=all
slave-skip-errors=all

 
原文地址:https://www.cnblogs.com/connected/p/13951599.html