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 **********************************************************************