List:General Discussion« Previous MessageNext Message »
From:Zhigang Zhang Date:February 26 2014 4:02am
Subject:RE: How to make multiple master to single slave in mysql?
View as plain text  
OK!

Thank you very much!

Zhigang.

-----Original Message-----
From: shawn l.green [mailto:shawn.l.green@stripped] 
Sent: Wednesday, February 26, 2014 11:57 AM
To: mysql@stripped
Subject: Re: How to make multiple master to single slave in mysql?



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
xiangdongzou@stripped)

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

Thread
How to make multiple master to single slave in mysql?Zhigang Zhang26 Feb 2014
  • Re: How to make multiple master to single slave in mysql?shawn l.green26 Feb 2014
    • RE: How to make multiple master to single slave in mysql?Zhigang Zhang26 Feb 2014