Marvin,
> The process is working between Master, Slave1 and Slave2 but
>for some reason Slave2 is not writing bin-log information.
> So Slave3 is sitting empty and not getting any data because of no data
> in Slave2's bin-log.
I guess u don't have 'log-slave-updates' flag enabled also along
with bin-log in Slave1 and Slave2 in order to have the updates from master
by slave sql-thread to be logged in their bin-log.
Have a look here
http://dev.mysql.com/doc/refman/5.0/en/replication-options.html
--Ravi
On Monday 27 February 2006 19:18, Marvin Wright wrote:
> Hi,
>
> I'm having a few problems at the moment with replication.
> We are in the process of migrating a cache to 2 new database machines.
>
> As the data is a cache its very large is refreshed constantly.
>
> Currently we have 2 machines, 1 master and 1 slave.
>
> I am trying to set up this configuration but I just can not get it to
> work.
>
> Master --> Slave1 --> Slave2 --> Slave3
>
> Master has id 1 and bin-log enabled
>
> Slave1 has id 2 and bin-log enabled but also a do-bin-log=Cache
>
> Slave2 has id 3 and bin-log enabled
>
> Slave3 has id 4
>
> The process is working between Master, Slave1 and Slave2 but for some
> reason Slave2 is not writing bin-log information.
> So Slave3 is sitting empty and not getting any data because of no data
> in Slave2's bin-log.
>
> The idea is to get this process working correctly, then the
> Slave2->Slave1 link broken and Slave2 will become the new Master.
>
> Any idea why this could be a problem ?
>
> All mysql versions are 4.1.12 and running on linux.
>
> Many Thanks
>
> Marvin Wright
> Flights Developer
> Lastminute.com
> [EMAIL PROTECTED]
>
>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **********************************************************************
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
