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 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


Subject Views Written By Posted
Replication began to work not always, not right away 1022 Dan Mor 03/31/2012 02:47PM
Re: Replication began to work not always, not right away 507 Rick James 04/01/2012 05:37AM
Re: Replication began to work not always, not right away 604 Dan Mor 04/02/2012 12:47PM
Re: Replication began to work not always, not right away 477 Rick James 04/03/2012 08:58AM
Re: Replication began to work not always, not right away 471 Dan Mor 04/04/2012 02:26PM
Re: Replication began to work not always, not right away 456 Rick James 04/05/2012 07:36PM
Re: Replication began to work not always, not right away 534 Dan Mor 04/06/2012 07:33PM
Re: Replication began to work not always, not right away 457 Rick James 04/07/2012 03:57PM
Re: Replication began to work not always, not right away 734 Dan Mor 04/07/2012 08:08PM
Re: Replication began to work not always, not right away 461 Rick James 04/08/2012 03:41PM
Re: Replication began to work not always, not right away 535 Dan Mor 04/14/2012 11:14AM
Re: Replication began to work not always, not right away 443 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.