MySQL Forums
Forum List  »  Replication

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.

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.