MySQL Forums
Forum List  »  Replication

Re: Replication began to work not always, not right away
Posted by: Dan Mor
Date: April 02, 2012 12:47PM

> Please provide details:
> * A sample UPDATE
> * SHOW CREATE TABLE
Any queries like "UPDATE table1 SET fieldA = # WHERE id = #"
Any simple tables tables with int/varchar fields. In myISAM/InnoDB
- no matter what table, what query.. problem seems global

> Meanwhile, what is the value of Seconds_behind_master in SHOW SLAVE STATUS (on the Slave)?
Of course it is 0 (zero).

> This is likely (but not always) to show a long-running query, such as ALTER on a big table. That will explain replication delays.
But it is not just delay. It is strange ignoring of starting queries, as a result - desynchronization.

For now relication I have working correctly.. After some time of working, I stops the slave, renew tables and start slave again, so for now I have synchronized databases that replicating good. But it will be interesting to know why that was happening... what if it will be again, when I wil recreate replication.



Edited 1 time(s). Last edit at 04/02/2012 12:48PM by Dan Mor.

Options: ReplyQuote




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.