TLDR: Replication Formats - Statement vs Row-based
Date: 2021-08-15 Source: https://arpitbhayani.me/blogs/replication-formats
Overview
Explore Master-Replica replication - Understand statement-based vs. row-based formats, advantages, and disadvantages for distributed systems. Master-Replica architecture is one the most common high-level architectural pattern prevalent in distributed systems.
Key Points
- Master-Replica architecture is one the most common high-level architectural pattern prevalent in distributed systems.
- Statement-based Format: In Statement-based format, the Master node records the operation as an event in its log, and when the Replica reads this log, it executes the same operation on its copy of data.
- Row-based Format: In Row-based format, the Master node logs the updates on the individual data item instead of the operation.