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 940 Dan Mor 03/31/2012 02:47PM
Re: Replication began to work not always, not right away 442 Rick James 04/01/2012 05:37AM
Re: Replication began to work not always, not right away 559 Dan Mor 04/02/2012 12:47PM
Re: Replication began to work not always, not right away 428 Rick James 04/03/2012 08:58AM
Re: Replication began to work not always, not right away 421 Dan Mor 04/04/2012 02:26PM
Re: Replication began to work not always, not right away 415 Rick James 04/05/2012 07:36PM
Re: Replication began to work not always, not right away 470 Dan Mor 04/06/2012 07:33PM
Re: Replication began to work not always, not right away 411 Rick James 04/07/2012 03:57PM
Re: Replication began to work not always, not right away 678 Dan Mor 04/07/2012 08:08PM
Re: Replication began to work not always, not right away 408 Rick James 04/08/2012 03:41PM
Re: Replication began to work not always, not right away 498 Dan Mor 04/14/2012 11:14AM
Re: Replication began to work not always, not right away 409 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.