MySQL Forums
Forum List  »  Replication

Re: About AUTO-INC In different mode (1,2 or 3)
Posted by: Peter Brawley
Date: April 21, 2021 10:13AM

Conceivably I might could, but I'd have a hard time finding motivation to fuss so about sequentiality. Autoinc guarantees uniqueness not sequentiality. Sequence is an issue for statement-based replication:

"Statement-based replication requires the consecutive auto-increment lock mode to ensure that auto-increment values are assigned in a predictable and repeatable order for a given sequence of SQL statements, whereas row-based replication is not sensitive to the execution order of SQL statements."

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: About AUTO-INC In different mode (1,2 or 3)
142
April 21, 2021 10:13AM


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.