MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
Posted by: Rick James
Date: June 25, 2016 10:55PM

> update crm_crmentity_seq set id=LAST_INSERT_ID(id+1)

I don't think that is a valid use of LAST_INSERT_ID().

You should only need
update crm_crmentity_seq set id=id+1
But that has a serious problem when dealing with Master-Master. Each Master could execute that at the same time, thereby getting the same ID for subsequent use.

Look at AUTO_INCREMENT and auto_increment_increment=2 and auto_increment_offset being different on each Master. That can guarantee no dups. (There are other details.)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Mysql 5.7.10 Master-Master replication stops with 1032 error
3368
Chintan Shah
June 02, 2016 08:23PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
6686
Chintan Shah
June 02, 2016 10:30PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
2987
Rick James
June 05, 2016 06:07PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
3372
Chintan Shah
June 05, 2016 10:43PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
2543
Rick James
June 07, 2016 03:49PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
2251
Chintan Shah
June 08, 2016 05:05AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
2249
Rick James
June 25, 2016 10:55PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
2039
Abdulla Saiyed
September 05, 2016 02:57AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1683
Rick James
September 05, 2016 09:39PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
4563
Abdulla Saiyed
September 05, 2016 10:33PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1827
Rick James
September 05, 2016 10:53PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1748
Abdulla Saiyed
September 05, 2016 11:02PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1845
Chintan Shah
November 23, 2016 06:48AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1828
james wang
November 24, 2016 03:35AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1412
Rick James
November 25, 2016 08:09PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1472
james wang
November 28, 2016 03:51AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1987
Edwin Desouza
November 25, 2016 08:46PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1454
Edwin Desouza
November 25, 2016 10:46PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1308
james wang
December 06, 2016 04:09AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1531
Edwin Desouza
December 06, 2016 12:41PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1615
james wang
December 07, 2016 04:30AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1620
james wang
November 28, 2016 03:49AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1642
Peter Brawley
November 28, 2016 11:50AM


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.