[eluser]Jondolar[/eluser]
Wouldn't the proper usage of a globally unique ID be when you actually need a globally unique id in your application? If your application is a blog, it probably was not specified or designed to allow all posts to be integrated with all other blogs on the planet. I would venture to say that there are times it makes sense to use a UUID (or GUID) but would be hard-pressed to believe that using a UUID for every pk makes sense. Data that is distributed makes sense (ads, feeds, others?). Data specific to your application and not designed to be distributed (transactions, products, comments) just doesn't seem like it would benefit having a UUID and there are many posts in this thread that point out the downfalls.
I read through all the posts but I don't remember seeing a specific description of how to actually retrieve the UUID that is generated by MySQL (or other database engine) when using the UUID() mysql function.