List:Replication« Previous MessageNext Message »
From:Andreas Stallmann Date:October 1 2012 12:33pm
Subject:Replication breaks - slave differs from master
View as plain text  
Hi!

One single table out of many differs after a while between mysql master and slave. The statement altering the table is:

UPDATE SEQ_GEN SET SEQUENCE_VALUE = SEQUENCE_VALUE + 10 WHERE SEQUENCE_NAME = 'Client_Object_SEQ'

We already checked, that no other process but the replication is altering the slave.

The logs show, that some transactions are completed in a different order on the master and the slave. Still, it’s in no way the obvious reason for the difference between the two hosts.

Any ideas? Any (kind) RTFMs? :-)

Cheers,

Andreas

--
CONET Solutions GmbH
Andreas Stallmann,
Theodor-Heuss-Allee 19, 53773 Hennef
Tel.: +49 2242 939-677, Fax: +49 2242 939-393
Mobil: +49 172 2455051
Internet: http://www.conet.de, mailto: AStallmann@stripped<mailto:AStallmann@CONET.DE>



----------------------------
CONET Solutions GmbH, Theodor-Heuss-Allee 19, 53773 Hennef.
Registergericht/Registration Court: Amtsgericht Siegburg (HRB Nr. 9136)
Geschäftsführer/Managing Director: Anke Höfer

 ----------------------------


Thread
Replication breaks - slave differs from masterAndreas Stallmann1 Oct
  • Re: Replication breaks - slave differs from masterMarcus Bointon1 Oct
    • RE: Replication breaks - slave differs from masterRick James1 Oct