摘要：
1.错误报告如下：当从二进制日志读取数据时，从主设备获取错误1236：“从设备使用CHANGEMASTERTOMASTER_AUTO_POSITION=1进行连接，但主设备已清除包含从属设备所需的GTID的二进制文件。”2.问题解决
1、报错如下：
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.'
2、问题解决：
查看master gtid_purged
show global variables like '%gtid%'; 找到gtid_purged的值
3、从库执行：
mysql> stop slave; Query OK, 0 rows affected (0.18 sec) mysql> reset slave; Query OK, 0 rows affected (1.29 sec) mysql> reset master; Query OK, 0 rows affected (1.18 sec) mysql> set @@global.gtid_purged='你的GITD值'; Query OK, 0 rows affected (2.12 sec) mysql> change master to master_host='MASTER_IP',master_port=PORT,master_user='USERNAME',master_password='PASSWORD',master_auto_position=1; Query OK, 0 rows affected, 2 warnings (5.55 sec) mysql> start slave; Query OK, 0 rows affected (0.40 sec) mysql> show slave status G *************************** 1. row *************************** Slave_IO_State: Queueing master event to the relay log Master_Host: xxx Master_User: xxx Master_Port: xxx Connect_Retry: 60 Master_Log_File: mysql-bin.002188 Read_Master_Log_Pos: 4925243 Relay_Log_File: mysql-relay.000002 Relay_Log_Pos: 117539 Relay_Master_Log_File: mysql-bin.002188 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: xxx Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table:xxx Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 117489 Relay_Log_Space: 4925493 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: 73626 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: xxx Master_UUID: xxx Master_Info_File: /data02/mysql/master.info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: System lock Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: xxx Executed_Gtid_Set: GTID值 Auto_Position: 1 1 row in set (0.45 sec)