The log files are GOD. They are your best friend. They are your guru. Thats all you need to know. There are at least a dozen various log files being written to at all times. Your answer will ALWAYS be in those log files. Just dig, then google.
:-) ed On 11/2/06, David Mintz <[EMAIL PROTECTED]> wrote: > 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 > > > -- the Blog: http://www.utopiaparkway.com the Karma: http://www.coderswithconscience.com the Projects: http://flickr.com/photos/[EMAIL PROTECTED]/ the Store: http://astore.amazon.com/httpwwwutopic-20 _______________________________________________ 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
