Architect

May 19, 2016 · Databases

Physical Replication in MySQL: Architecture, Log Management, and Performance Evaluation

This article explains the design and implementation of InnoDB‑based physical replication for MySQL, covering background concepts, advantages over native binlog replication, high‑level architecture, log file handling, instance roles, MVCC handling, failover procedures, and performance test results.