I got three Fedora Core 4 boxes -- let's call them 1, 2, and 3 -- running MySQL 5.0.17 and I had chained replication running great until I broke it yesterday with an ill-advised query.
Server 1 is master; server 2 is a slave to #1; server 3 is a slave to #2, or is supposed to be -- that's what's broke. I did everything by the book (http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html). On server 3, 'show slave status' shows it thinks it's doing fine. When data is changed on server 1, server 2 updates as it should, but server 3 nevertheless does not. 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. Ideas? Thanks, --- 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
