MySQL Forums
Forum List  »  NDB clusters

NBBCluster not sync autoincrement values between mysql server nodes
Posted by: Tony Soprano
Date: September 15, 2023 04:55AM

I have a NDBcluster on 2 physical servers with this layout:
vm1 ndb manager + mysql server #1
vm2 mysql server #2
vm3 data node #1
vm4 data node #2

i import many dbase on vm1 using mysql commnand line.
i can see and access all data from both vm1 and vm2.
but after 2 months of perfect usage,
vm2 mysql server if i insert data in any table of any dbase start to use
weird and not syncronized value for autoincrement of any id primary key.

example:
on vm1: insert into user (name,email) values ("tony","t@t.com")
insert into user (name,email) values ("john","f@f.com")
result on both vm1 and vm2:
id=8 , name=tony, email=t@t.com
id=9 , name=john, email=f@f.com

then i do on vm2:
insert into user (name,email) values ("kris","k@k.com")
result on both vm1 and vm2:
id=8 , name=tony, email=t@t.com
id=9 , name=john, email=f@f.com
id=521 , name=kris, email=k@k.com

Can someone explain me why this happen? why after 2 months and how to fix this please!



Edited 2 time(s). Last edit at 09/15/2023 04:57AM by Tony Soprano.

Options: ReplyQuote


Subject
Views
Written By
Posted
NBBCluster not sync autoincrement values between mysql server nodes
104
September 15, 2023 04:55AM


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.