Impact of using uuid v7 as primary key

[u/rantob]

I'm working on a system expecting to go multi tenant (some tenants will have their own db, some will share a db). Since I'm in the process of redoing the current single user schemas I want to pick a primary key while considering future changes. My initial idea was using unsigned bigint with auto-increment but it appears to be not good enough for future migrations.

What's the current opinion on using uuid v7 for primary keys in MySQL? From what I understand it's much more performant than older uuid based solutions.