HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Single slave - multiple master MySQL replication

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
slavereplicationmysqlmastersinglemultiple

Problem

I need to replicate different MySQL databases from multiple servers into a single slave server. How can this be done? is there a way to define multiple master hosts?

Solution

As of October 2013 MySQL (> 5.7.6) supports multi-source replication.

MySQL Multi-Source Replication in MySQL Reference Manual

http://www.mysqlperformanceblog.com/2013/10/02/mysql-5-7-multi-source-replication/

http://on-mysql-replication.blogspot.com/2013/09/feature-preview-mysql-multi-source-replication.html

Context

StackExchange Database Administrators Q#40379, answer score: 5

Revisions (0)

No revisions yet.