You can paste the show slave status\G here for us to review and on Master, show global variables like 'log-bin%'; show master status ( 3 to 4 times continuously )
On Fri, Aug 29, 2014 at 5:11 PM, wagnerbianchi.com <m...@wagnerbianchi.com> wrote: > Hello guys, some points to check here: > > 1-) Is the master server configured with sync_binlog=1 ? > 2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading > events from master, is the Exec_Master_Log_Pos incrementing or not? > 3-) Why are you reconfiguring all the replication just because the link > went down? > > Cheers, > -- > *WB* > > 2014-08-29 17:46 GMT-03:00 Andrew Moore <eroomy...@gmail.com>: > > > 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 > > > > > > > > > -- -- Thanks Suresh Kuna MySQL Database Consutant & MongoDB DBA Hadoop Admin