MySQL Forums
Forum List  »  Replication

error reconnecting to master
Posted by: sok bunthoeun
Date: September 02, 2020 09:49PM

Hello everyone

I have setup and configure MySQL Master-Master Replication on Window server 20212 R2

Currently, I'm facing the issue on the happen on node 2 'Last_IO_Error: error reconnecting to master 'repl@10.8.8.27:1755'

So. I concern data not replicate from node 1 to node 2


If anyone know the issue happened , please help guide me



mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.8.8.27
Master_User: repl
Master_Port: 17555
Connect_Retry: 60
Master_Log_File: mysql-bin.000107
Read_Master_Log_Pos: 939469753
Relay_Log_File: biodr-relay-bin.005248
Relay_Log_Pos: 134318466
Relay_Master_Log_File: mysql-bin.000107
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 939469753
Relay_Log_Space: 134318766
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 2003
Last_IO_Error: error reconnecting to master 'repl@10.8.8.27:1755
5' - retry-time: 60 retries: 86400
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)

mysql>

Options: ReplyQuote


Subject
Views
Written By
Posted
error reconnecting to master
218
September 02, 2020 09:49PM
103
September 03, 2020 09:49AM
71
September 29, 2020 01:30AM
87
September 29, 2020 10:06AM
67
September 29, 2020 08:15PM
71
September 29, 2020 10:30PM
76
September 30, 2020 02:32AM
66
October 05, 2020 09:27AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.