Hi @Eliot Chen ,
There are a couple of issues that I think will prevent you from choosing the integrated cache in Cosmos DB at this time:
- It's still in preview. That means there is no SLA for availability. The documentation states that you should expect comparable availability with the rest of your Cosmos DB account.
- During the public preview, you can't provision a dedicated gateway in Cosmos DB accounts in a Vnet, nor can you provision it with availability zones. There are other limitations such as no RBAC controls, firewalls etc that are currently in place: https://learn.microsoft.com/en-us/azure/cosmos-db/dedicated-gateway#limitations
- I'm not sure where you are deploying your resources, but currently the dedicated gateway isn't supported in every region (this will change once it goes GA): https://learn.microsoft.com/en-us/azure/cosmos-db/dedicated-gateway#supported-regions
- The integrated cache is limited to the SQL API during the preview.
- Once you provision the dedicated gateway, you can't modify the size of the nodes, but you can add and remove nodes as needed (up to 5 nodes at the time of writing).
To state the obvious, the integrated cache for Cosmos DB will be tied to Azure Cosmos DB. If you have use other databases (such as SQL Server), you wouldn't be able to use the integrated cache for Cosmos.
Hopefully this helps! It would be interesting to hear more about your use case if possible to go into a bit more depth with you on the integrated cache in Cosmos DB.