Distribued Application and Primary keys with HIGHLOW

[Laurent Fabre]

Hi guys,

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 ? :)

Best Regards,

LF

[Ady]

Hello Laurent Fabre,

 Have you tried the 'Synchronous Data Replication'? This should work for you because based on the description the HIGHLOW generated key value will be a part of a 2-phase commit transaction in the cluster.

Greetings,

Ady

the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Laurent Fabre]

You may be right I'll look into it.

Thanks,

LF