I make use of the Forward Mapping feature in OpenAccess to design my MySQL Database and originally I was using the auto_increment offset trick to support circular replication (which was so bad from a performance point of view).
I went all the way correcting my code to use HIGHLOW generator and it's working like a charm. But then I'm wondering, what are the prerequisites to prevent two nodes in my cluster from coming up with the same generated key in this setup ?
MSMQ could be an anwser ? Like a short one non-allienating one for instance ? :)