Whilst there are a few possibilities, check on the master that your binary logs are being written to. Another possible reason could be filtering. On 29 Aug 2014 21:36, "william drescher" <will...@techservsys.com> wrote:
> > Replication novice > > I have a master server at the office and a replication server at home. > This setup has been working for a couple of years. Occasionally the > replication server gets out of sync (usually following a internet problem > and the vpn going down.) > I just stop the slave, make sure there is nothing going to the master > (when the office is closed), > copy the database, > transfer the file, > load the backup, and > start the slave and all is well. > > This time there was not a communications problem of which I am aware. The > slave status said the slave_IO_state was "Waiting for master to send event" > but it was not replicating. > > I did the usual > > now it is not updating the replication database (transactions made on the > master do not show on the slave - using phpMyAdmin on both servers) BUT > show master status shows the correct log file and the position is > incrementing AND show slave status shows the same master log file and the > same position as the master. So, looking at the status info it seems to be > running fine, but the transactions do not appear to appear on the slave. > > I seek suggestions how to 1) find out what goes wrong when the vpn goes > down, and 2) (much more important now) how to find out whether or not the > slave is actually replicating or not. > > --bill > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >
