From: sean c peters
Date: September 16 2005 7:16pm
Subject: UUIDs - first usage for me
List-Archive: http://lists.mysql.com/mysql/189188
Message-Id: <200509161416.52919.speters@wiredata.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi all,=20
Im researching switching a production database system to use UUID's instead=
 of=20
AUTO_INCREMENT columns for various ids. I've looked at various MySQL=20
documentation, and it seems to be what i want.=20
This change will really affect 2 separate database servers. Both are using=
=20
InnoDB tables. One is running MySQL 4.1.3-beta on solaris, and the other is=
=20
running 4.1.8-Max on Redhat Linux.=20

=46rom what i've been reading, the only thing i cant determine is what colu=
mn=20
type to use to store the UUID's. These will be foreign keys between some=20
tables, and the unique ids in all tables for this system.=20

Should i be using BINARY() columns ?

Thanks much

=2D-=20
Sean Peters
Senior Programmer, WIREData Inc.
speters@stripped

"The software required Windows 2000 or better, so i Downloaded Linux"