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)
105
April 21, 2021 10:13AM


Sorry, only registered users may post in this forum.

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.