Impact of Column Differences on MySQL RBR Master‑Slave Replication

This article explains why, in MySQL row‑based replication, a master table having an extra column does not disrupt replication to a slave table lacking that column, provided column order, placement, and default values meet specific conditions, and demonstrates the behavior with a MySQL 5.7.25 test.

Master‑SlaveRBRReplication

0 likes · 4 min read

Impact of Column Differences on MySQL RBR Master‑Slave Replication

Xueersi Online School Tech Team

Oct 23, 2020 · Databases

MySQL Replication: Master‑Slave Configuration, Binlog Formats, and Protocol Details

This article explains MySQL master‑slave replication by covering SBR, RBR, and MBR concepts, step‑by‑step configuration of master and slave servers, binlog format settings, the underlying replication protocol, key SQL commands, and troubleshooting tips, all illustrated with real code snippets and diagrams.

BinlogMBRMaster‑Slave

0 likes · 18 min read

MySQL Replication: Master‑Slave Configuration, Binlog Formats, and Protocol Details

ITPUB

Jan 8, 2016 · Databases

How Facebook Scales MySQL Backups: Strategies, Storage, and Incremental Techniques

This article explains Facebook's large‑scale MySQL backup architecture, covering the Python‑based automation framework, master‑slave deployment, logical mysqldump backups, warm and cold storage locations, source selection heuristics, full and incremental backup pipelines, verification processes, and future RBR‑based improvements.

FacebookHDFSIncremental Backup

0 likes · 15 min read