David What do you see in the log files?
Explore the Evolving Web www.2.0websites.com Paul Yurt, Publisher paul(@)2.0websites.com 480-585-0007 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Mintz Sent: Thursday, November 02, 2006 8:32 AM To: MySQL SIG Subject: Re: [mysql] need help w/ replication On Thu, 2 Nov 2006, David Mintz wrote: > > I notice that the output 'show master status' on server 2 (master to > server 3) does not change -- ever, unless I reboot mysqld and it creates a > new file. So although binary logging is enabled according to my.cnf, it > does not seem that binary logging is happening. My hypothesis is, that's > the problem. Server 3 is 'waiting for master to send event' and thinks > nothing is happening. Correction: server #2 'show master status' shows a higher value for 'postion' if I do something like create and drop a database on server 2. Server 3 does replicate those changes as well. But the changes made on server 1, which are replicated by server 2, are not replicated on server 3. --- David Mintz http://davidmintz.org/ En Nueva York el tránsito de la belleza a la desolación sucede siempre expeditivamente, como si el principio universal de máxima eficiencia hubiera aconsejado la supresión de gradaciones intermedias. -- Antonio Muñoz Molina, Ventanas de Manhattan _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
