Distribued Application and Primary keys with HIGHLOW

3 posts, 1 answers
  1. Laurent Fabre
    Laurent Fabre avatar
    28 posts
    Member since:
    Apr 2009

    Posted 19 Dec 2009 Link to this post

    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
  2. Answer
    Ady
    Admin
    Ady avatar
    588 posts

    Posted 23 Dec 2009 Link to this post

    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.
  3. DevCraft banner
  4. Laurent Fabre
    Laurent Fabre avatar
    28 posts
    Member since:
    Apr 2009

    Posted 06 Jan 2010 Link to this post

    You may be right I'll look into it.

    Thanks,

    LF
Back to Top