You are here

Home » Blogs » Shinguz's blog

MySQL Multi-Master - Single-Slave - Replication

Thu, 2006-12-21 16:39 — Shinguz

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!!!

Taxonomy upgrade extras: 
multi-master
slave
replication
multi-source

Comments

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.
olicomment Wed, 2012-01-04 17:05

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!
olicomment Thu, 2012-01-05 17:44