Link You Today
Bookmark your Free, Libre software & tech link

Store UUID in an optimized way

mariadb, mysql, percona

Many people store UUID as char (36) and use as row identity value (PRIMARY KEY) because it is unique across every table, every database and every server and allow easy merging of records from different databases. But here comes the problem, using it as PRIMARY KEY causes the problems described below.