On Mon, Nov 12, 2012 at 5:21 AM, Machiel Richards - Gmail <machiel.richa...@gmail.com> wrote: > 1. the fact that the slaves say "seconds behind master = 0" does not > neccesarily mean that repliication is working as I have found this a lot of > times where it shows 0 then have proven that replication was not working > (I.e. data not being processed on the slave). The 0 seconds simply means > that it has read all the data but does not mean that it has been processed > or up to date. > 2. the Exec_Master_Log_Pos and Master_Log_File are in fact out of > sync with the master (i.e. on the master the file and log position are way > ahead of the slaves by about 9 hours). > 3. We have tested replication by creating a test table in the > database with some data and it was not replicated to the slaves.
show global variables like 'slave_net_timeout'; I'll bet it's some giant number so the slave just doesn't realize that it's lost its connection. ...Todd -- The total budget at all receivers for solving senders' problems is $0. If you want them to accept your mail and manage it the way you want, send it the way the spec says to. --John Levine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
