MySQL InnoDB Primary Key Choice: GUID/UUID vs Integer Insert Performance When working with MySQL it is common to choose auto incrementing integer primary keys; however, there are situations where using a GUID/UUID is desirable. For example, prior to MySQL 5.0, you were unable to safely use auto incrementing primary keys in a multi-master replicated setup due to potential (and inevitable) duplicate