Hi All,
We are using MySQL-EE and have a topology of multi-source replication between 4 development servers (for DBA playground use ofcourse).
We have accidentally performed a flush logs and purge of binlog on one of the masters (xtsdb08)
Can you please identify what to do in such case in order to restore IO from master?
Here is the show slave status for channel 'from_xtsdb08'\G output:
mysql> show slave status for channel 'from_xtsdb08' \G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: xtsdb08.dev1.bos.credorax.com
Master_User: replicator
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: xtsdb06-relay-bin-from_xtsdb08.000001
Relay_Log_Pos: 4
Relay_Master_Log_File:
Slave_IO_Running: No
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: 0
Relay_Log_Space: 376
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: 1236
Last_IO_Error: 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.'
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 4
Master_UUID: 1ccc47d1-5e17-11e6-97db-0050569f10e0
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp: 160906 13:35:59
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: 29364a62-5e17-11e6-a318-0050569f5547:1,
d9188168-5e0e-11e6-a3f9-0050569f0e7a:1
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name: from_xtsdb08
Master_TLS_Version:
1 row in set (0.00 sec)
Thanks,
Haim