MySQL Forums
Forum List  »  Replication

Re: error reconnecting to master
Posted by: sok bunthoeun
Date: September 30, 2020 02:32AM

Hello Peter Brawley

Thanks for your updated

I will show our message error on mysql database to you now

if we to check make sure replication master to master

How to check it ? , Not sure configure master-master or not


--DC-Side
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: x.x.1.37
Master_User: repl
Master_Port: 17555
Connect_Retry: 60
Master_Log_File: mysql-bin.000108
Read_Master_Log_Pos: 470149494
Relay_Log_File: biodc-relay-bin.006322
Relay_Log_Pos: 251
Relay_Master_Log_File: mysql-bin.000108
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: 470149494
Relay_Log_Space: 551
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: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)


--DR-Side

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: x.x.8.27
Master_User: repl
Master_Port: 17555
Connect_Retry: 60
Master_Log_File: mysql-bin.000110
Read_Master_Log_Pos: 316236907
Relay_Log_File: biodr-relay-bin.005521
Relay_Log_Pos: 125416090
Relay_Master_Log_File: mysql-bin.000110
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: 316236907
Relay_Log_Space: 125416390
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>

Regards
Bunthoeun

Options: ReplyQuote


Subject
Views
Written By
Posted
237
September 02, 2020 09:49PM
112
September 03, 2020 09:49AM
81
September 29, 2020 01:30AM
97
September 29, 2020 10:06AM
75
September 29, 2020 08:15PM
79
September 29, 2020 10:30PM
Re: error reconnecting to master
83
September 30, 2020 02:32AM
75
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.