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
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?
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN