Tuesday, September 13, 2011

Last_IO_Error: error connecting to master 'repl@' - retry-time: 10 retries: 86400

This error you get when you check " show slave status\G;"

Solution as follows:
Do Telnet:

[root@sj ~]# telnet 3666
Connected to
Escape character is '^]'.
uHost '' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.

Do Flush host:

[root@sj ~]# mysqladmin -uroot -ppassword flush-hosts

Lets check " show slave status\G;" again.