David Moreau Simard

3 minute read

It happens. You have a Master -> Slave MySQL replication and your master crashes for a reason or another. You’re worried about bringing the master back online as soon as possible. When you finally get it back up, you notice the slave is stopped, complaining about a dreaded error that looks a bit like this: Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘binlog truncated in the middle of event; consider out of disk space on master; the first event ‘mysql-bin.