MySQL主从配置的时候slave从服务器的slave查看中出现:
Got fatal error 1236 from master when reading data from binary log: 'The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires. 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 '5b8bb2c5-8e7f-11ed-9c74-000c2980d652:1-10,
5b9f373d-8e7f-11ed-8bd4-000c294822b0:1-8', and the missing transactions are '5b8bb2c5-8e7f-11ed-9c74-000c2980d652:11-20'.'
参考解决方法:
(1)在从服务器这边设置:
(2)在主服务器master查看master信息并刷新log:
(3)在从服务器slave这边配置:
重新配置slave的信息在重新启动连接;