Skip to main content

Binlog for Replication & Recovery

Learn Binlog for Replication & Recovery (Binary Logs, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction The binlog is the transport and the history. A replica's I/O thread copies events from the source's binlog into a relay log, and a SQL thread applies them. For recovery, mysqlbinlog replays the same events onto a restored backup.

More lessons in Binary Logs