Re: multiple replications

Yes, a few suggestions :-)

1. change the binlog names: one for each server - the positions might be not exactly the same between all of them at any given time (theoreticaly it shouldn't behave with any differences at all, but sometimes it can happen). I believe that changing explicitly the binary log name, server and position gives you more awareness on how the situation is.
2. log_slave_updates is an switch, not an option=something (just put lot_slave_updates on the config file). It makes the server write down to it's own binary log everything that it has executed that comes from a different server-id different that his own.
3. did you checked on the server-ids? Are you sure there are no duplicates on your setup?

Regards,

-- 
Augusto Bott

On 8/2/07, Database System  wrote:

>
> Note: forwarded message attached.
>
> Thanks Augusto,
>
> I had log-bin="mypath/binlog" in my.ini file on server
> B. Now I added:
> log-slave-updates="mypath/binlog" in the same .ini
> file. And restarted the server.
> But the new logfile on B is still no update.
>
> The reason I setup same directory and same log file
> name is because once server B become master again, I
> don't need to reconfig replication, the slave (server
> C) always goes to same place to read binlog, no mater
> server B is master or slave.
>
> Any suggestions?
> Thanks,
> Lisa
>
>
>
>
>
> ____________________________________________________________________________________
> Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated
> for today's economy) at Yahoo! Games.
> http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow
>
>
> ---------- Forwarded message ----------
> From: "Augusto Bott" <augusto@bott.com.br>
> To: database100@yahoo.com
> Date: Wed, 1 Aug 2007 18:57:02 -0400
> Subject: Re: multiple replications
> Are you using  log-slave-updates?
> If not, check http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
>
> --
> Augusto Bott
>
> On 8/1/07, Database System <database100@yahoo.com> wrote:
> >
> > Hello,
> >
> > I had servers A, B, and C. Version 5.0X
> > C is the slave of B.
> > B was a master. But since B became a slave of server
> > A, it never update its binlog. Therefore, C is not
> > updated. what's wrong?
> >
> > Thanks advance,
> > Lisa
> >
> >
> >
> >
> >
> > ____________________________________________________________________________________Ready
> > for the edge of your seat?
> > Check out tonight's top picks on Yahoo! TV.
> > http://tv.yahoo.com/
> >
> > --
> > MySQL Replication Mailing List
> > For list archives: http://lists.mysql.com/replication
> > To unsubscribe:
> > http://lists.mysql.com/replication?unsub=augusto.bott@gmail.com
> >
> >
>
>
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=augusto.bott@gmail.com
>