Re: Replication began to work not always, not right away
Posted by:
Rick James
Date: April 01, 2012 05:37AM
> after I set "slave-skip-errors=1062,1146"
Not a good idea. It would be better to find, and fix, the causes of these errors.
> when I do some UPDATE-queries on MASTER, SLAVE renew the log-position, nut DO NOT make changes to database field values!!
Please provide details:
* A sample UPDATE
* SHOW CREATE TABLE
> when some time passed (some hours), changes began appear
Meanwhile, what is the value of Seconds_behind_master in SHOW SLAVE STATUS (on the Slave)?
If you ever see Seconds_behind_master being significantly greater than zero, do
SHOW PROCESSLIST
(on the Slave). This is likely (but not always) to show a long-running query, such as ALTER on a big table. That will explain replication delays.