Skip navigation links

MySQL Forums :: Replication :: Replication began to work not always, not right away


Advanced Search

Re: Replication began to work not always, not right away
Posted by: Rick James ()
Date: April 07, 2012 03:57PM

The Host (in the PROCESSLIST) is NULL ??? Please describe the topology of your Master and Slave -- same or separate machines? TCP/IP connection? Other?
(I don't know what to make of that. I hope the Master and Slave are not on the same machine.)

SHOW MASTER STATUS; -- on Master
SHOW SLAVE STATUS \G -- on Slave
(I'm fishing for binlog/replicate-do/ignore and anything else out of the ordinary.)

Check the clocks on the two machines; the seem to be at least 8 seconds apart.
(I don't think this could cause the trouble, but you probably should fix it.)

> `ip` varchar(20) NOT NULL,
Overkill for IPv4; inadequate for IPv6.
(Unrelated issue.)

Please do these on both machines:
CHECK TABLE ibf__uag_banlist;
CHECK TABLE ibf__uag_gvars;
(Since you are using MyISAM, a REPAIR may be needed.)

Options: ReplyQuote


Subject Views Written By Posted
Replication began to work not always, not right away 984 Dan Mor 03/31/2012 02:47PM
Re: Replication began to work not always, not right away 471 Rick James 04/01/2012 05:37AM
Re: Replication began to work not always, not right away 586 Dan Mor 04/02/2012 12:47PM
Re: Replication began to work not always, not right away 448 Rick James 04/03/2012 08:58AM
Re: Replication began to work not always, not right away 446 Dan Mor 04/04/2012 02:26PM
Re: Replication began to work not always, not right away 436 Rick James 04/05/2012 07:36PM
Re: Replication began to work not always, not right away 493 Dan Mor 04/06/2012 07:33PM
Re: Replication began to work not always, not right away 436 Rick James 04/07/2012 03:57PM
Re: Replication began to work not always, not right away 714 Dan Mor 04/07/2012 08:08PM
Re: Replication began to work not always, not right away 431 Rick James 04/08/2012 03:41PM
Re: Replication began to work not always, not right away 517 Dan Mor 04/14/2012 11:14AM
Re: Replication began to work not always, not right away 420 Rick James 04/15/2012 11:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.