Yahoo! JAPAN

This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source ...

The binary log contains “events” that describe database changes such as table creation operations or changes to table data. It also contains events for ...

For replication to work, first of all master needs to be writing replication events to a special log called binary log. This is usually very lightweight ...

The replica's relay log, which is written by the replication I/O (receiver) thread, contains the transactions read from the replication source server's ...

2020/4/9 -Replication: A record of the changes in data is provided by the binary log on a replication source server, which is meant to be sent to replicas ...

The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log.

2024/3/15 -MySQL replication starts with enabling the binary log (binlog). The binlog contains a record of events that represent changes to the database.

2019/1/17 -Master-slave replication is based on binary logs. The master writes all transactions into its binary log. The slave reads the transaction from ...

Binary logs, or commonly known as binlogs contain events about the changes done to the database, like table structure changes, data changes via DML operations, ...

With binary logging enabled, the server logs all statements that change data to the binary log, which is used for backup and replication. The binary log is a ...