Better Parallel Replication for MySQL

Parallel replication is a much-expected feature of MySQL. It’s available in MariaDB 10.0 and in MySQL 5.7. Yet, both lose efficiency when replicating through intermediate masters. In this post, we’ll explain how parallel replication works and why it does not play well with intermediate masters. We’ll also offer a solution (hint: it involves Binlog Servers).

Photo by Master Wen on Unsplash
----Time---->
T1: B---C
T2: B---C
T3: B-------C
T4: B-------C
----Time---->
T1: B---C
T2: B---C
T3: B-------C
T4: B-------C
----Time--------->
T1: B---C
T2: B---C
T3: B-------C
T4: B-------C

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store