Replication Formats-opracowanie

Replication Formats
Replication works because events written to the binary log are read from the master and then
processed on the slave. The events are recorded within the binary log in different formats according
to the type of event. The different replication formats used correspond to the binary logging format
used when the events were recorded in the master's binary log. The correlation between binary logging
formats and the terms used during replication are:
• Replication capabilities in MySQL originally were based on propagation of SQL statements from
master to slave. This is called statement-based replication (often abbreviated as SBR), which
corresponds to the standard statement-based binary logging format. In older versions of MySQL
(5.1.4 and earlier), binary logging and replication used this format exclusively.
• Row-based binary logging logs changes in individual table rows. When used with MySQL replication,
this is known as row-based replication (often abbreviated as RBR). In row-based replication, the
master writes events to the binary log that indicate how individual table rows are changed.
• The server can change the binary logging format in real time according to the type of event using
mixed-format logging.
... zobacz całą notatkę