On 2/25/2014 9:55 PM, Zhigang Zhang wrote: > How to make multiple master replicate to single slave in mysql? > > > > Tell me some approaches? > >
Put your masters in a replication ring, hang a slave from one of them (as suggested by Mr. Van der Westhuizen) Use an external product, such as GoldenGate, that can collect data from multiple sources and perform the steps necessary to keep the MySQL instance you are calling the "slave" updated. (as mentioned by xiangdong...@gmail.com) Write your own daemon or script to poll each master, in turn, by adjusting the slave's replication configuration in some kind of round-robin technique (several of these scripts are on the web). Using the native replication process, no MySQL versions (5.7 or earlier) support one slave replicating data from multiple masters. It is possible to have multiple slaves replicating from a single master but you cannot have one slave repicating from multiple masters. Why are you not reading the responses you are getting? Regards, -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
