MySQL Forums
Forum List  »  Replication

Consecutive numbers in a master-to-master replication scenario
Posted by: Ben Klauke
Date: August 13, 2014 05:56AM

Hi,

We want to set up a master-to-master replication due to failover reasons. As we've noticed it's necessary to work with auto_increment_increment and auto_increment_offset to control the operation of AUTO_INCREMENT columns. Is there anyhow some trick to generate consecutive numbers (e. g. for bill numbers) in this scenario?

Thank you so much for your help.

All the best,

Ben

Options: ReplyQuote


Subject
Views
Written By
Posted
Consecutive numbers in a master-to-master replication scenario
1493
August 13, 2014 05:56AM


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.