Multi Source Replication – MariaDB

Home » MySql » Multi Source Replication – MariaDB
November 28, 2015 MySql No Comments

As with version 10.0.1, it is now possible to use multiple masters as source for single slave node as replication topology.

This link can help you set up the replication from a single master. To add more masters just use the ‘CHANGE MASTER TO’ command and use different master addresses.

Update: Follow this to setup basic replication.


To add two masters, use


This should create a multi-source instance in MariaDB which will consolidate data from all your sources.

To view all your sources, run the SHOW ALL SLAVES STATUS \G command from your slave MariaDB instance.