Re:Do you make these 5 database design mistakes?
by jaylevitt on Tuesday January 03, 2012 @01:14PM
(#3420620)
Interesting.. how do you deal with ID collisions after rollover? That was our big problem, even with 8-byte IDs - the ID allocator had to know the Global Truth. Dealing with collisions as "exception, try the next one" was too expensive, though with faster hardware that may be moot.
[ Parent
| on HN ]
Re:Do you make these 5 database design mistakes?
by emmelaich on Saturday January 07, 2012 @06:46PM
(#3438417)
Yes, rollover is an interesting problem. With the app and scale that we're operating at that will not happen within the next few thousand centuries though.
I'm actually describing how I might go about doing it, and what I /think/ Oracle RAC does.
I'm not actually certain as to the implementation.