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.
...
GitHub - sony/sonyflake: A distributed unique ID generator inspired by Twitter's Snowflake
TWITTER SNOWFLAKE GENERATOR
The maximum timestamp can be represented in 41 bits is :
2^41 -1 = 219902325551 milliseconds (ms) which gives : approx. 69 years = 219902325551 ms / 1000 / 365 days / 24 hours / 36 seconds.
ID Generator will work for 69 years. After that, we will need a new epoch time !