Stewart Smith wrote:
On Tue, Aug 12, 2008 at 10:43:16AM -0700, Robert Hodges wrote:
Some of the previous data type conversations reminded me of a question
that's been on my mind for a while. What do you think of dropping
auto-increment keys and replacing them completely with UUIDs?
Auto-incrementing is one of the banes of horizontal scaling so it seems
reasonable to substitute something that works across partitions and data
copies. Or at least to give application developers an opportunity to
suppress it.
Depends on how you use them... we do horizontal scaling in NDB and we
deal with auto inc fine (we prefetch batches of them). So if you were more
cloud like, there is no reason why you couldn't have something like this
plugged into the sql server.
I would think that "auto increment" has some additional semantics that
cannot be fulfilled here? You are not incrementing from the previous
value, but from the previous value registered at this server.
Roy
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
