This blog continues the ongoing series on
daily operations and GTID replication.
In this blog, I’m going to investigate why
the error below has been appearing in a special environment I’ve
been working with on the last few days:
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.'
The error provides the right message, and explains what
is going on. But sometimes, it can be a bit tricky to solve
this issue: you need additional information discovered after some
tests and readings. We try and keep Managed Services
scripted, in the sense that our advice and best …[Read more]