Issue with Sequence Increment in Galera Cluster
I have set up a sequence in a Galera Cluster environment consisting of 3 database nodes, configured with NOCACHE and increment BY 0. The generated sequence increases by 3 (e.g., the number following 4 is 7). Could you explain why this is happening? Is this the expected behavior? If I want the sequence to increment by 1, how should I configure it?
Answer Answered by Daniel Black in this comment.
0 implies it uses auto_increment_increment which in galera is set to the cluster number of member ref create sequence.
If you INCREMENT BY 1 with NOCACHE that should work (did for the user of MDEV-33766).
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
