Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: multiple replications

From: Database System <database100(at)yahoo.com>
Date: Thu Aug 02 2007 - 10:55:30 EDT


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

attached mail follows:


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  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=lists@pantek.com Received on Thu Aug 2 10:55:56 2007

Do you need help?X

This archive was generated by hypermail 2.1.8 : Thu Aug 09 2007 - 19:30:25 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library