I'm creating a system that is not entirely microservices, but it's getting close to microservices and each module has its own database.
And based on what I have seen in many online services (Azure, AWS, Google Cloud, etc.) I have used
UUID (or GUID) for my identifications.
This means that in the
Orders database, I have
CustomerUuid column. So, if I want to query a customer's orders, I should use
where CustomerUuid = 'uuid_valu'.
To boost reading performance for all
UUID I have this plan to put an index on every
What negative impacts this decision might have? What are the cons for this strategy?
Datebase = MariaDB
Version = 10.10.2
IDENTITYinteger? And if you want to use UUIDs then make the foreign key columns in the child also UUID. You seem to indicate that the UUID must be an entirely separate column, why?