SQL example creating table with auto-increment.
...
There are four versions of UUIDs.
UUID1 uses MAC address and timestamp to generate effective uniqueness.
UUID3 and UUID 5 uses cryptographic hashing and application-provided text strings to generate UUID. (UUID 3 uses MD5 hashing, and UUID 5 uses SHA-1 hashing).
UUID4 uses pseudo-random number generators to generate UUID.
TICKET SERVER
MySQL’s Replace Into Statement can help to make MySQL auto-increment work across multiple databases, set up a dedicated database with a single table and a single record whose sole purpose is to provide unique and incremental ID.
...
A thorough understanding of snowflake algorithm and Baidu meituan’s best practice | Develop Paper
SonyFlake generator
GitHub - sony/sonyflake: A distributed unique ID generator inspired by Twitter's Snowflake