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.

Example

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.

LEAVE A COMMENT