MySQL How To Overcome UUID Issues In A Distributed System?
We have a distributed system which consists of an Identify Provider (idP)
which handles user authentication and authorization. The idP
associates a UUID
with a user and issues JWT Access Tokens
which contain the UUID
as a JWT claim
. We also have a MySQL database (DB)
which stores user meta-data. The UUID
used to identify the User by the idP is stored in the DB, this allows us to establish a connection between the idP user and their DB meta-data.