BTW, Monty created a non-standard 64-bit UUID for mysql that makes use
of the server's replication server-id... see uuid_short() at
http://dev.mysql.com/doc/refman/5.1/en/miscellaneous-functions.html
It's:
(server_id & 255) << 56 +
(server_startup_time_in_seconds << 24) +
incremented_variable++;
On Aug 13, 2008, at 7:56 AM, Robert Hodges wrote:
Hi Brian and others,
Performance and storage seem to be at the heart of UUID usability
for many applications. Older UUID implementations had a host-
specific part (e.g., MAC address) to which a local value was added.
This would help with size but has problems of its own when you move
or replicate data to other locations.
Basically what many applications need is a mechanism to generate
globally non-conflicting keys efficiently within shards but not pay
a penalty for using them locally. Perhaps a segmented UUID where
the first part is a shard identifier might be a solution.
Cheers, Robert
On 8/12/08 10:47 AM, "Brian Aker" <[EMAIL PROTECTED]> wrote:
Hi!
I would be very happy to add an UUID type to Drizzle. The only thing
to be aware of though is that it is a 16byte INT which means it will
be slower on comparison. I personally think this is fine, but it is
something to consider.
Cheers,
-Brian
On Aug 12, 2008, at 10:43 AM, Robert Hodges wrote:
> Hi everyone,
>
> 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.
>
> Thanks, Robert
>
> --
> Robert Hodges, CTO, Continuent, Inc.
> http://scale-out-blog.blogspot.com
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~drizzle-discuss
> Post to : [email protected]
> Unsubscribe : https://launchpad.net/~drizzle-discuss
> More help : https://help.launchpad.net/ListHelp
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
--
Robert Hodges, CTO, Continuent, Inc.
Email: [EMAIL PROTECTED]
Mobile: +1-510-501-3728 Skype: hodgesrm
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
