You are here

MySQL Multi-Master - Single-Slave - Replication

MySQL provides its replication for High Availability (HA) and for read Scale-out. Generally it is known that in a MySQL replication you can only replicate from one Master to many slaves. In this paper it is shown how a set-up can look like to replicate from two masters to one slave.

Caution: Handle this information with care!!!


This concept/PoC is old! Nowadays we do not need this anymore. What in this blog post was described nowadays is called Multi-Source Replication. If you really need Multi-Source Replication I would go for Tungsten Replicator.

Rumbi pointed me to a bug in the PDF! The first Slave S should point to Master M on port 3315. I have fixed the PDF now. Thanks Rumbi!