Is there anybody has done what I'm trying to do?
I successfully setup master to master replication between A and B. Now I'd likr to add C
to replicate A, mean A is also master of C. I need to make sure updates on B will also
indirect replicated to C.
Thanks,
Lisa
--- On Mon, 3/8/10, Mats Kindahl <mats@stripped> wrote:
> From: Mats Kindahl <mats@stripped>
> Subject: Re: Addutional slave to a master-to-master replication
> To: database100@stripped> Cc: replication@stripped> Date: Monday, March 8, 2010, 2:36 PM
>
>
> Database System wrote:
> > Hi,
> >
> > I have one master A , and two slaves B and C both
> replicate A.
> >
> > Now I want to change A and B as master to master
> replication. I know how to setup A and B. I'm not sure if I
> need to do any change on C, in order it execute all
> statements once and won't miss any statements. For example,
> updates on A, and updates original done on B, but
> replicated/executed on A.
>
> Hi Lisa,
>
> I'm not sure what problem you're trying to solve, but
> replication
> between A and B will work since A will prune any events
> tagged with
> its server ID. For events that originate from C you have to
> be careful
> since those events will not be pruned by any server if they
> get into
> the loop between A and B.
>
> Note that you cannot replicate from two masters at the same
> time
> (unless you resort to various tricks), so you have to
> re-direct the A
> and B server to each others. If you are too quick in
> re-directing the
> A and B servers, it might be that there are C events in the
> binlog for
> either A or B, and they will then circle forever, and being
> executed a
> lot of times.
>
> Just my few cents,
> Mats Kindahl
>
> >
> > Thanks,
> > Lisa
> >
> >
> >
> >
>
> --
> Mats Kindahl
> Senior Software Engineer
> Database Technology Group
> Sun Microsystems
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication> To unsubscribe: http://lists.mysql.com/replication?unsub=1>
>

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.