Writings on various topics (mostly technical) from Oliver Hookins and Angela Collins. We currently reside in Sydney after almost a decade in Berlin, have three kids, and have far too little time to really justify having a blog.
I had a fairly frustrating time today trying to explain to someone that
indeed the order of actions matters very much when trying to recover
failed replication on a MySQL server. We had a good dump from the master
taken with --single-transaction --master-data=2 (yes, all InnoDB
tables here), and had imported it successfully. However, at the critical
moment of reading the binary log name and…