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

tags: 
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.

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

oli comment Thu, 2012-01-05 17:44