mysql双主架构——主从断连

mysql双主架构
日志报错信息：
Cannot replicate to server with server_uuid='xxx' because the present server has purged required binary logs. The connecting server needs to replicate the missing transactions from elsewhere, or be replaced by a new server created from a more recent backup. To prevent this error in the future, consider increasing the binary log expiration period on the present server. The missing transactions are 'xxx'.

2023-05-23T11:07:25.024232Z 5 [System] [MY-010562] [Repl] Slave I/O thread for channel '': connected to master 'xxxx@ip:3306',replication started in log 'mysql-bin.000107' at position 546946688 2023-05-23T11:07:25.025386Z 5 [ERROR] [MY-010557] [Repl] Error reading packet from server for channel '': Cannot replicate because the master purged required binary logs. Replicate the missing transactions from elsewhere, or provision a new slave from backup. Consider increasing the master's binary log expiration period. The GTID set sent by the slave is xxx', and the missing transactions are '@@GTID' (server_errno=1236) 2023-05-23T11:07:25.025414Z 5 [ERROR] [MY-013114] [Repl] Slave I/O for channel '': Got fatal error 1236 from master when reading data from binary log: 'Cannot replicate because the master purged required binary logs. Replicate the missing transactions from elsewhere, or provision a new slave from backup. Consider increasing the master's binary log expiration period. The GTID set sent by the slave is 'xxx'
分别查询

MySQL>show global variables like'%gtid%'\G

获得A

Variable_name: gtid_purged
        Value: 86bdc8ab-e1ba-11ed-965c-005056ad6d03:1-67278259:76207330-76207504

和另一台的B

Variable_name: gtid_executed
        Value:86bdc8ab-e1ba-11ed-965c-005056ad6d03:1-78248170

由此可得知，A的数据比B的数据少，所以应该是之前断电重启后，A复制B的数据出现了问题，造成主从断连

解决方法：
B

MySQL>stop slave;
MySQL>reset slave all;

A

MySQL>stop slave;
MySQL>reset master;
MySQL>set @@GLOBAL.GTID_PURGED='@@GTID';
--@@GTID为之前日志中显示传输失败的日志
MySQL>change master to master_host=‘ip’，master_port='port',master_auto_position=1;
MySQL>start slave;
MySQL>show slave status\G

             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes

B

MySQL>start slave;
MySQL>show slave status\G


             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes

恢复正常！