Cosmos DB Mongo Optimize cost reads writes

Migrate mongodb 1

Hi, I migrated from mongo db into cosmos db and I have a trouble with cost.

Detail information as below:

StorageSize 300GB
Collections 200
Object 1500M
DataSize 1100GB
Indexes 400
IndexSize 60GB

I started migrate db one week ago and tested service by myself, with a few request by manual. However, estimate cost show that I spent more than 15000$.
Because query run very slow, so I set 150k RU per second. This is main reason for out of budget to migrate DB.

I found one url about using reads connection. Currently, my service written by php, in source code, I didn't separate read-write connection. Could you give me some advice for this problem? We need to configure read-write connection or not?
https://learn.microsoft.com/en-us/azure/cosmos-db/optimize-cost-reads-writes

And this price for service is too expensive for only migrate data progress. For migrate data from old mongo db into cosmos like this which number of RU I could set for my database, just for I could run my service as normally with only one user. to scale, I will calculate it later.

KalyanChanumolu-MSFT 8,316 Reputation points

2020-08-24T12:06:39.917+00:00

@Migrate mongodb Thank you for your interest in Azure Cosmos DB. We are sorry you are having an unpleasant experience.
We will try and help you resolve this.

Where are you seeing an estimated cost of 15K? If this is from CostAnalysis blade in the Azure portal, it is a prediction based on the previous accumulated costs.
Since migration was a one time activity, the estimate might not be entirely accurate.

You do not need to have separate connections for read and write. The article talks about how the billing for reads and writes are calculated separately

We cannot give a general recommendation on the number of RU's without understanding your workload because it depends on the kind of reads/writes you are doing, how your documents are indexed etc.

Could you please confirm if you used the CosmosDB Migration Tool or some other tools for migration?
Migrate mongodb 1 Reputation point

2020-08-26T04:21:23.117+00:00

Hi @KalyanChanumolu-MSFT , thank you for your replying. I used the CosmosDB Migration Tool.
KalyanChanumolu-MSFT 8,316 Reputation points

2020-08-26T04:52:27.097+00:00

@Migrate mongodb
Thank you for confirming.

Please let us know any further questions or concerns regarding the migration or costs.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

Share via

Cosmos DB Mongo Optimize cost reads writes