RE: How to make multiple master to single slave in mysql?

2014-02-25 Thread Zhigang Zhang
OK! Thank you very much! Zhigang. -Original Message- From: shawn l.green [mailto:shawn.l.gr...@oracle.com] Sent: Wednesday, February 26, 2014 11:57 AM To: mysql@lists.mysql.com Subject: Re: How to make multiple master to single slave in mysql? On 2/25/2014 9:55 PM, Zhigang Zhang wro

Re: How to make multiple master to single slave in mysql?

2014-02-25 Thread shawn l.green
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

How to make multiple master to single slave in mysql?

2014-02-25 Thread Zhigang Zhang
How to make multiple master replicate to single slave in mysql? Tell me some approaches? Thanks Zhigang

RE: Multi-master to one slave

2014-02-25 Thread Brian Van der Westhuizen [DATACOM]
Dont understand your question ? But If you have 2 masters replicating to each other, yes you can a have a single slave hanging from either those servers. Things to keep In mind Each server have unique server id Make the slave read only If you have very little experience in DBA'ng and particul

回复: Multi-master to one slave

2014-02-25 Thread xiangdongzou
DEAR zhang: You can use GoldenGate do that. 2014-02-25 I AM AN ORACLE FANS! Skype:Frank.oracle Email:xiangdong...@gmail.com 发件人："Zhigang Zhang" 发送时间：2014-02-25 12:06 主题：Multi-master to one slave 收件人："mysql" 抄送： Does someone have the best schema from multi-master to one slave exclu