<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Stefan! This is like holding all your eyelids apart and shouting out for somebody with a sharp stick! ;)<div><br><div><div>Watcha gonna do when you add a third server?</div><div><br></div><div>er.. lemme see... Multiply all OIDs by three and allocate new OIDs modulo three? </div><div><br></div><div>Eeek!</div><div><br></div><div>Why not make the OID a composite of server ID and sequence? Even if these were both packed in the same 64 bits, just so you keep it a *little bit nasty*, and then maybe just get one eye poked out! ;) </div><div><br></div><div>(You could get away with a byte for the server ID, leaving masses of bits for the item ID.)</div><div><br></div><div>Best wishes!</div><div><br></div><div>--r</div><div><br><div><br><div><div>On 22 May 2008, at 14:49, Stefan H. Holek wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi Russ,<br><br>This is correct. I should have mentioned that the two servers are configured so that server A creates odd, server B even sequence numbers. This makes the duplicate id error pretty mysterious, IMO ;-)<br><br>Stefan<br><br>On 22.05.2008, at 13:15, Russ Ferriday wrote:<br><br><blockquote type="cite">I have not read the reference, but it seems that this scheme can never work without keys (OIDs) being qualified by which master they originated on. Otherwise one of the mySQLs would need to be responsible for handing out unique oids. You need an OID origination namespace for each master.<br></blockquote><br>--<br>Stefan H. Holek<br><a href="mailto:stefan@epy.co.at">stefan@epy.co.at</a><br><br><br><br><br></blockquote></div><br><div> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Verdana; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; color: rgb(0, 0, 0); font-family: Verdana; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; -webkit-text-decorations-in-effect: none; text-indent: 0px; -webkit-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div id="sig" style="line-height: 13px; margin-top: 4px; margin-right: 0px; margin-bottom: 4px; margin-left: 0px; padding-top: 2px; padding-right: 4px; padding-bottom: 2px; padding-left: 4px; font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 10px; color: black; "><div style="float: left; padding-top: 2px; padding-right: 6px; padding-bottom: 2px; padding-left: 6px; background-color: rgb(238, 238, 238); font-size: 10px; font-weight: bold; line-height: 13px; "><strong style="font-size: 10px; font-weight: bold; line-height: 13px; "><span class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; ">Russ Ferriday</span></strong><span class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><span class="Apple-converted-space"> </span>-<span class="Apple-converted-space"> </span></span><a href="http://topia.com/" title="visit topia.com" style="text-decoration: none; color: rgb(102, 102, 102); font-size: 10px; font-weight: bold; line-height: 13px; "><span class="Apple-style-span" style="color: rgb(102, 102, 102); font-size: 10px; font-weight: bold; line-height: 13px; ">Topia Systems</span></a><span class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><span class="Apple-converted-space"> </span>- Open Source content management with Plone and Zope</span><br style="font-size: 10px; font-weight: bold; line-height: 13px; "><a href="mailto:russf@topia.com" style="text-decoration: none; color: rgb(102, 102, 102); font-size: 10px; font-weight: bold; line-height: 13px; "><span class="Apple-style-span" style="color: rgb(102, 102, 102); font-size: 10px; font-weight: bold; line-height: 13px; ">russf@topia.com</span></a><span class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><span class="Apple-converted-space"> </span>- office: +44 2076 1777588 - mobile: +44 7789 338868 - skype: ferriday</span></div></div></div></span></div></span> </div><br></div></div></div></div></body></html>