The Problem with Using a UUID Primary Key in MySQL (opens in new tab)

One approach I didn't see discussed here is storing the UUID across 2 columns as 2 64 bit integers and forming a composite primary key. There's still tradeoffs with this as with all the methods but depending on use case it's viable way to do it.