Description:Currently the last_io_error column in SHOW SLAVE STATUS causes quite a bit of confusion. Firstly the error contains no DATETIME so you have no idea when the problem occurred: Last_IO_Error: error connecting to master 'foo@boo' - retry-time: 60 retries: 86400 Lastly there is ...
0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 2003 Last_IO_Error: error connecting to master 'repl@127.0.0.1:3306' - retry-time: 60 retries: 86400 Last_SQL_Errno: 0 Last_SQL_Error: 1 row in set (0.00 sec) mysql> Suggested fix: Reset the values when RESET SLAVE is issued.[...