MySQL Forums
Forum List  »  Replication

Replication Lagging
Posted by: Mahendra Singh Bisht
Date: January 25, 2016 06:24AM

Hello All,

I am facing issue with the replication lagging on one of the server(Master-Master replication setup).On one server when I do show full processlist, it shows no query running and the replication is in sync on it whereas on the other server I see many Delete queries running and on this server the replication is lagging and sometime it fluctuates.

Reference query :

delete from Serv_Us where nodeid='ee208f37028242cc9596b12cbf8a42f6';

The above query comes 12-15 times(Thread) with different nodeid.

MySQL Error logs shows :

2016-01-25 11:53:00 39283 [Warning] Slave SQL: Error 'Deadlock found when trying to get lock; try restarting transaction' on query. Default database: 'xyz'. Query: 'insert into serv_us (requestnr, authorizedreqnr, completedreqnr, serviceid, nodeid) values (73, 73, 71, x'0CB3CCA9E88BEC838E592C905FD9D4E4', 'e0f18008c2dd4979b183afff1918d108')', Error_code: 1213

The Serv_Us tables has Primary key as nodeid.

Kindly help on this.

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication Lagging
1394
January 25, 2016 06:24AM
938
January 29, 2016 06:45PM
986
January 30, 2016 12:02AM
782
January 30, 2016 08:48PM
830
January 31, 2016 03:14AM
851
February 01, 2016 11:14AM
857
February 02, 2016 10:35PM
803
February 04, 2016 10:42PM
843
February 04, 2016 11:13PM
763
February 06, 2016 04:20PM
841
February 08, 2016 02:15AM
776
February 13, 2016 05:45PM


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.