NBBCluster not sync autoincrement values between mysql server nodes

[Tony Soprano]

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","[e-mail]")
insert into user (name,email) values ("john","[e-mail]")
result on both vm1 and vm2:
id=8 , name=tony, email=[e-mail]
id=9 , name=john, email=[e-mail]

then i do on vm2:
insert into user (name,email) values ("kris","[e-mail]")
result on both vm1 and vm2:
id=8 , name=tony, email=[e-mail]
id=9 , name=john, email=[e-mail]
id=521 , name=kris, email=[e-mail]

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.