环境是两台服务器做的主主备份,A服务器从B服务器同步的时候会遇到状态都正常就是A服务器的Read_Master_Log_Pos和B服务器的不一致,相差200多万, B服务器从A服务器复制一切正常.
相关信息如下:
A服务器的show slave statusG的结果
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.100.100
Master_User: slave
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000005
Read_Master_Log_Pos: 211001228
Relay_Log_File: iZ23rdfmxjuZ-relay-bin.000034
Relay_Log_Pos: 2651540
Relay_Master_Log_File: mysql-bin.000005
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: 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: 211001228
Relay_Log_Space: 70547558
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:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 180
Master_UUID: d69b94b2-c40d-11e6-914b-c80aa98819df
Master_Info_File: /var/lib/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
B服务器上的show master status;
mysql> show master status\G;
*************************** 1. row ***************************
File: mysql-bin.000005
Position: 212286606
Binlog_Do_DB: l4d2_wykh
Binlog_Ignore_DB:
Executed_Gtid_Set:
1 row in set (0.02 sec)
Slave_IO_Running 和 Slave_SQL_Running 都正常只有pos出现不一致的问题
目前临时解决办法是在A服务器上stop slave然后start slave就好了,重启slave就会进行同步.
