Tuesday, September 13, 2011

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

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

Solution as follows:
Do Telnet:

[root@sj ~]# telnet 12.18.46.78 3666
Trying 12.18.46.78...
Connected to 12.18.46.78.
Escape character is '^]'.
uHost '12.18.46.78' 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.

Done.

1 comments:

Renu said...

Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
Devops Training in electronic city