patternsqlMinor
Single slave - multiple master MySQL replication
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
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.