Skip navigation.
Home

Languages

RSS Feed FromDual on Linked In Recommend us on Xing Join us on Facebook Google+ Flickr Contact us

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

Bug in PDF

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!

Old concepts, please do not use anymore...

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.