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.