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
