azure for mysql data in replication failure

Question

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.'  

I was trying to set up replication from another cloud provider to azure, but after restoring the initial data, I keep getting an error above. Do you have suggestions about this?

Answer 1

Hi @Ratna Kristiawati Thank you for posting your Question on Microsoft Q&A and for using Azure services.

My understanding is that you are trying to set up a replication from another cloud provider to azure but facing an issue after restoring the initial data. Please let me know if my understanding is not correct.

The value of gtid_purged should be same as gtid_executed on master for GTID-based replication to work.
show global variables like 'gtid_executed';
Please make sure that you have configured the source MySQL server

Also, there are certain limitations and considerations to take into action before staring the replication.

https://learn.microsoft.com/en-us/azure/mysql/howto-data-in-replication

Regards,
Oury