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
3256
Chintan Shah
June 02, 2016 08:23PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
6429
Chintan Shah
June 02, 2016 10:30PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
2876
Rick James
June 05, 2016 06:07PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
3318
Chintan Shah
June 05, 2016 10:43PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
2425
Rick James
June 07, 2016 03:49PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
2214
Chintan Shah
June 08, 2016 05:05AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
2219
Rick James
June 25, 2016 10:55PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1809
Abdulla Saiyed
September 05, 2016 02:57AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1651
Rick James
September 05, 2016 09:39PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
4423
Abdulla Saiyed
September 05, 2016 10:33PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1793
Rick James
September 05, 2016 10:53PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1716
Abdulla Saiyed
September 05, 2016 11:02PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1810
Chintan Shah
November 23, 2016 06:48AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1799
james wang
November 24, 2016 03:35AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1378
Rick James
November 25, 2016 08:09PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1436
james wang
November 28, 2016 03:51AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1891
Edwin Desouza
November 25, 2016 08:46PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1345
Edwin Desouza
November 25, 2016 10:46PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1280
james wang
December 06, 2016 04:09AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1315
Edwin Desouza
December 06, 2016 12:41PM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1370
james wang
December 07, 2016 04:30AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1511
james wang
November 28, 2016 03:49AM
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
1600
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.